Forum Discussion
Connecting an API to Power BI
Hi dgarcia
I still think you should run some HTTP requests via Postman to see how the data is being returned. Without having access to the API myself, I am afraid I can't help much more. Are you able to generate an API key for me to test with, that you can delete/change later?
It also appears that you're going to have to iterate over the data, as the documentation suggests there is pagination. I've found this article to be helpful in the past.
I tried it on Postman! Very easy to navigate once you get the hang of it. Thank you for the suggestion! It works fine with Postman and pulls all the information correct.
I just need to figure out how to do it in power bi for some reason I keep getting a different error now.
Details: "Block length does not match with its complement."
Also for some reason on the application we cannot delete our API keys yet but I requested to have a temporary API key to see if you might be able to help me troubleshoot. I think the problem is with power bi not being able to pull the information not with actual API. Or it's me not know what I'm doing!!
- TaylorN6 years ago
Helper I
Hi dgarcia
That particular error relates to GZIP compression (from memory) and is a .NET exception. I'm not sure exactly how to fix it, but perhaps you could fiddle around with the "Content-Encoding" header on the HTTP request? i.e. set the Content-Encoding header to a value of gzip.
- Peter_Jeyaraj_I4 years ago
Helper II
Hi,
Any luck ? I am on the same stage now. Please refer https://community.powerbi.com/t5/Desktop/PowerBI-Connection-to-Synergi-life-API/m-p/2297856#M832227
Got stuck on the authentication stage itself for the past 1 week.