cancel
Showing results for 
Search instead for 
Did you mean: 

Web API data source refresh issue

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 fine. But when i publish the report to powerbi.com it fails the data refresh with an exception "Invalid Credentials" and the configured header value is not available in the data connection. need help in fixing this issue

 

Thanks 

Sowjanya

Status: New
Comments
Member

Hi

 

I think this is still the best workaround when base URL is not anonymous. Works like a charm.

1)Create Azure Function.


AzureFunction.png

This is like a proxy API  and it is anonymous so cloud refresh will not get any credential errors.

Function content is different, depending on what u want to do. This is for solving basic auth problem in my case.

 

2) Here is an example, how i use this function in powerbi desktop.

 

PowerBiDesktopSource.png

 

I hope this solves your problems also.

 

Thanks.

Idea Statuses