Results in PowerBI

Hi @DSP2020 Welcome to the community! I sadly don’t know too much about connecting to PowerBI (as we don’t have a native integration), but I’ve reached out to our tech support team to see if they know anything! I’ll post back if they have any advice. :) 

@Paulo @john.desborough do either of you work with PowerBI?

@john.desborough thanks! That’s was the original plan to figure it out tomorrow   I hope it works 

@DSP2020 How did this go for you? Were you able to set this up? 

Thanks Liz.

Still working on it.

Cheers, William

in power BI go to get data>blank query. In the query window put

 = Json.Document(Web.Contents("https://api.typeform.com/forms/yourformID/responses", [Headers=[Authorization="Bearer tfp_yourKey"]]))

If you get any issues, change the query to anonymous. From there, click on into table in the top left and then it’s just expanding and flattening out the data so power bi can use it… You’ll also want to import the form as a lookup.

Thanks for sharing @robotsWhoFeelLove and welcome to the community! 😊

@robotsWhoFeelLove thanks for the inputs

I tried doing the same, though I’m getting this error in power query while connecting.

Could you / everyone who is reading this post kindly let me know what would be causing this, because I took the response ID and the Bearer token by generating the API key and filled in the URL to load in power query

Any assistance would be highly appreciated in this regard.

Thanks!

It’s been quite awhile since I had to do this, but I think your credentials are in the wrong place.

If I’m not mistaken, switching to anonymous removes the key you’ve entered directly into power BI. Once this is done, the credentials need to be in the query itself, added as a header manually, I only see a header for timeout in your query. I also don’t know what your url variable is, but my query works with just the api address. (Form ID (3) is just my variable for the form ID)

:

I believe you also need to add in the fqdn in anonymous (I.E.. the URLs should match the full path)

Thanks for the help, @robotsWhoFeelLove ! Let us know if that ends up working for you, @hausandhaus