Power BI: Using anonymous authentication on Web data sources with a API key in URL

Currently, there are some challenges on Power BI service when trying to Schedule Refresh from a Web API data source that uses an API key for authentication. On this post, I will talk about a way to work around this problem by using an Azure Functions Proxy. The proxy will be used the override the request to the Web API and successfully use anonymous authentication.

Scenario overview

I have some reports on Power BI that get the data from WorkflowMax API, they have been published on Power BI service and embedded on SharePoint Online.… [Keep reading] “Power BI: Using anonymous authentication on Web data sources with a API key in URL”