Refresh not possible in Power BI online

[jarkelen]

Hi,

I have a report with a web API as data source. The authentication is Anonymous and the privacy level is Public:

The actual authentication is within where it uses a Bearer token to authenticate:

This works fine in Power BI Desktop, when I click the Refresh button the data gets refreshed.

However, in Power BI online this fails, the settings are the same however:

So I have no idea why it is working in Desktop but failing Online?

Any ideas would be appreciated!

[ibarrau · Accepted solution]

Hi. Have you tried skipping the test connection? APIs can be difficult to validate authentication at service. Desktop will just run code without validations. I have a similar issue with power bi rest api that was fixed just skipping the text for the request.

I hope that helps,

[jarkelen]

Yes! That made the difference indeed!

Thanks, wasn't expecting that this would make a difference.