Forum Discussion
Community ChampionIs presented with an error of incorrect credentials using Direct Query
Hello Power BI champions,
I am struggling with a peculiar issue which goes as below:
So I have created a repport using the data from Azure SQL Database in Direct Query mode, direct query connection made using credentials - [email protected](hypothetical)
Now I publish it in the service using the account [email protected] (hypothetical)
When trying to view the data in Power BI service, it gives me an error:
"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."
And when I try to edit the credentials to take the admin azure credentials, it says failed to sign in.
Is it not possible for Power BI to relate the main account([email protected] ) with the corresponding admin azure account(here - [email protected] )
I am looking for any sort of leads that clears out the issue for me.
Thanks a lot in advance
So it turned out that the visuals were not updating as the accont under which it was published was different([email protected]) where as the credetials used for connecting to Azure SQL database in Direct Query mode were different(
I had to feed proper credentials for the Dataset by going to the Settings -->Dataset --> Edit Credentials
Screenshot below:
Also, changed the Authentication method from Basic to Auth2, screenshot below:
> With Basic:
With OAuth2:
Before making the changes error:
After making the changes:
4 Replies
- lbendlin
Super User
You say you use Direct Query, but the error message says "data source can't be refreshed" which implies that somewhere you use Import mode?
PC2790Yes, from one of the sources I am getting the data using Import mode.
But I was not getting
Is it because of that? But earlier, when I was using only Import mode, I was not getting this error
- lbendlin
Yes, that is the cause. In your dataset settings, refresh all credentials.
- PC2790
So it turned out that the visuals were not updating as the accont under which it was published was different([email protected]) where as the credetials used for connecting to Azure SQL database in Direct Query mode were different(
I had to feed proper credentials for the Dataset by going to the Settings -->Dataset --> Edit Credentials
Screenshot below:
Also, changed the Authentication method from Basic to Auth2, screenshot below:
> With Basic:
With OAuth2:
Before making the changes error:
After making the changes:
