Your data source can't be refreshed because the credentials are invalid.

Question

I know there are few questions asked in the community specifying the same issue and I have gone through all of them but they don't apply to my scenario.

I have an api on my azure cloud with AAD authentication and I am using this api as data source via web connector in Power BI desktop. On Power BI desktop I am able to dynamically generate token through power query code, connect to the web api(anonymous access) and create a report from it. Refresh is also happening perfectly.

However when I published my report on to Power BI service and tried to refresh there I get the following error

On further investigation I went to settings and found this

It shows me Anonymous and Basic access method on the Power BI service for credentials

Any idea how to get past this?

My power query code is :

amitchandak · Answer

Anonymous , while setting up Scheduler you have an option for the gateway ? Have you tried that?

anonymous · Answer

amitchandak&nbsp; I did not try data gateway because my data source is in the cloud.&nbsp; But the option for gateway is greyed out for me&nbsp;&nbsp;