Forum Discussion
Web API connection
- 4 years ago
Hi Sam_Jain ,
hard to tell, quickly went through all the other answers here without checking all the links and details.
So I assume that you're using anonymus authentication with the key?
If that's not working, I would recommend to compare the generated queries by Postman and PBI using Fiddler or any other tool.
See where the queries differ and try to adjust accordingly.
Update: I was able to establish the connection by passing the api key name and key value in the web option and then choosing anonymous while signing in.
My next step here is to write the code to include the necessary metrics and a scheduled refresh. Any links towards those.
Thank you all for your help!
- Peter_Jeyaraj_I4 years ago
Helper II
Hi Sam,
Can you please share how you managed to authenticate.. Still i got stuck to establish the connection.
See the below error. but everything works fine in Postman
- Sam_Jain4 years ago
Helper III
Hey Peter_Jeyaraj_I Sorry for the delay in response.
You can overcome that error by entering the api key name as well as value on the Get Data->Web->Advanced
Enter the URL and under the Request Header Parameters enter the key name alongside with the Key value.
And then choose Anyonymous under authentication.
Tio note - In this case the value was passed via header so if that's how it works for you on Postman as well then this should be the solution.
Again apologies for the delay.
Thanks.
- Peter_Jeyaraj_I4 years ago
Helper II
Hi Sam_Jain
Yes, it was working fine when i add "Bearer" in front of the key value.. anyhow, thank you