Hi Team, I have created a web api which validates the http header and gives the response in Json format. I have added this api as a data source for a report in power bi desktop which is working f...
Do you have any update? I have the same issue - Web API authentication works in the desktop, but fails auto-refresh when published.
I am using Json.Document(Web.Contents("...", [ApiKeyName="Api-Token")) to retrieve data from the REST API call, Cloud Power BI connection authentication does not even provide the "Web API" option.
Writing authentication key value directly into Web.Content (authentication header) has the same problem. Works in Power BI desktop, but fails refreshes when published into the cloud.
Please let me know if this is a known issue, and if so, any timeline for the fix?
Thank you!