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...
mikihiir
Helper III
7 years agoHi
I think this is still the best workaround when base URL is not anonymous. Works like a charm.
1)Create Azure Function.
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.
I hope this solves your problems also.
Thanks.