Invalid Credentials in Power BI Service

[niki_b]

Hi,

I am trying to refresh my data in Power BI service but it returms me an error saying invalid credentials.

I am using my organizations's apis to get data in Power BI desktop. I have generated bearer token in the Advanced Editor itself and set up the credentials to anonymous in desktop app. 

I am trying to set the credentials to anonymous in service as well. But it is not working. My ultimate goal is to set up scheduled refresh for the data in service. How can I resolve this issue?

Thanks

[ranbeermakin · Accepted solution]

@niki_b This will not work since the power query will try to query the root URL. You may use a gateway and skip test connection. Read more here: https://powerbi.microsoft.com/en-us/blog/skip-test-connection-for-on-premises-and-cloud-data-sources...

[niki_b]

Thanks. I kind of figured it out later.