Forum Discussion
Refreshing data from REST API works on Desktop, fails on Service
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.
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.
Thank you, very helpful!
Thanks for posting this solution I managed to refresh in power bi service only time will tell if the fresh data will pull through but have been working on this issue for days,
the blog post says when you enter your credentials in settings then you are overiding your authentication method in power query, so you need to create a gateway connection with skip test selected.
