Forum Discussion
dgarcia
6 years agoRegular Visitor
Connecting an API to Power BI
Hello Everyone, I'm having the hardest time connecting a to PowerBI via API with a key. I'm not sure where to start I have zero experience with API. While connecting the API I get an erro...
dgarcia
6 years agoRegular Visitor
Hey ,
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!!
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!!
TaylorN
Helper I
6 years agoHi 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.