Forum Discussion

Frequent Visitor

6 years ago

Solved

Refreshing data from REST API works on Desktop, fails on Service

I'm using PowerBI to retrieve data from a REST API, and this works fine on Desktop but fails to refresh (either scheduled or manual) on Service, using Anonymous access. The code is ...

Need Help

Jayendran
6 years ago
Hi brunborg ,

I think it's this error is not releated to the headers (fields). Basically the autentication is you are handling with your side using your own Basic Autentication from the Power Query. If you choose the Anonymous it will override all the autentication in your report. Can you just try to use a gateway for your case ?

Using the gateway,there is an option called Skip Connection.

You can also follow my article for the reference, which I've dealt with the same sort of process.
https://community.powerbi.com/t5/Community-Blog/Power-BI-Gateway-Monitoring-amp-Administrating-Part-2/ba-p/750765

Jayendran

Solution Sage

6 years ago

Hi brunborg ,

I think it's this error is not releated to the headers (fields). Basically the autentication is you are handling with your side using your own Basic Autentication from the Power Query. If you choose the Anonymous it will override all the autentication in your report. Can you just try to use a gateway for your case ?

Using the gateway,there is an option called Skip Connection.

You can also follow my article for the reference, which I've dealt with the same sort of process.

https://community.powerbi.com/t5/Community-Blog/Power-BI-Gateway-Monitoring-amp-Administrating-Part-2/ba-p/750765