cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PC2790
Solution Sage
Solution Sage

Is 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 - adm-azr-abc.xyz@organisation.com(hypothetical) 

Now I publish it in the service using the account abc.xyz@organisation.com (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(here-abc.xyz@organisation.com ) with the corresponding admin azure account(here - adm-azr-abc.xyz@organisation.com )

I am looking for any sort of leads that clears out the issue for me.

 

Thanks a lot in advance

1 ACCEPTED SOLUTION
PC2790
Solution Sage
Solution Sage

So it turned out that the visuals were not updating as the accont under which it was published was different(abc.xyz@organisation.com) 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:

PC2790_1-1619077244943.png

Also, changed the Authentication method from Basic to Auth2, screenshot below:

> With Basic:

PC2790_2-1619077303086.png

With OAuth2:

PC2790_3-1619077570981.png

 

Before making the changes error:

PC2790_0-1619077182790.png

After making the changes:

PC2790_4-1619077631941.png

 

 

 

View solution in original post

4 REPLIES 4
PC2790
Solution Sage
Solution Sage

So it turned out that the visuals were not updating as the accont under which it was published was different(abc.xyz@organisation.com) 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:

PC2790_1-1619077244943.png

Also, changed the Authentication method from Basic to Auth2, screenshot below:

> With Basic:

PC2790_2-1619077303086.png

With OAuth2:

PC2790_3-1619077570981.png

 

Before making the changes error:

PC2790_0-1619077182790.png

After making the changes:

PC2790_4-1619077631941.png

 

 

 

View solution in original post

lbendlin
Super User III
Super User III

Yes, that is the cause. In your dataset settings, refresh all credentials.

lbendlin
Super User III
Super User III

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?

Yes, 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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors