Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PC2790
Community Champion
Community Champion

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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

 

 

 

lbendlin
Super User
Super User

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

lbendlin
Super User
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?

PC2790
Community Champion
Community Champion

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors