Hi there,
I made a survey with calculator and want to visualise the score on a PowerBI dashboard. Is integration possible or with other dashboard visualisations?
Cheers, William
Hi there,
I made a survey with calculator and want to visualise the score on a PowerBI dashboard. Is integration possible or with other dashboard visualisations?
Cheers, William
Hi
des
I hope it works
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
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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.