cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Credentials Error on Refreshing

I have a report/dashboard that has been published for about 4 - 5 months now without any changes, and the scheduled refresh was working fine. Suddenly last week, the report refuses to refresh. I get the following error:

"Credentials are required to connect to the SQL source"

 

I have entered the credentials and know they are correct, as i use the same credentials to refresh the desktop file without any issues

 

Its only this 1 specific report, i have other reports using the same connection to the same db, and don't experience this issue.

 

Has anyone come across this or know what may be causing it?

 

The report connects to Azure for the db

6 REPLIES 6
Highlighted
Frequent Visitor

Re: Credentials Error on Refreshing

Hi 

We are experiencing the same error with connection to Azure SQL database.

Any fix? 

Regards,

Tony

Highlighted
New Member

Re: Credentials Error on Refreshing

I'm having same issues but with Quickbooks online.  I'm extremely disappointed.  This issue first came up in August and lasted about 1.5 months and was finally resolved.  Everything was working fine until 3 days ago when I started receiving the "invalid credentials" error again. I'm disappointed because I know now I can't rely on this tool; I have to go back to my client and tell them I can't deliver their promised reports.

Highlighted
Resident Rockstar
Resident Rockstar

Re: Credentials Error on Refreshing

Make sure you submit this as a bug report, as well. You can do so in PBI Desktop by using the 'Send a frown' option in the File menu, and using the feedback menu in PBI Service.

The forums are a great avenue for discussing issues, sharing thoughts / ideas, and troubleshooting, but they are not the official medium to submit bug reports.

Proper bug reports will receive more attention from the devs than forum posts.

Highlighted
Frequent Visitor

Re: Credentials Error on Refreshing

thanks for the response,

 

i have done feedback in the desktop, frown in the service, and raised an issue in the office 365 admin panel, havent gotten a response as yet from MS, was hoping someone here had experienced the issue and found a resolution to to it.

Highlighted
Frequent Visitor

Re: Credentials Error on Refreshing

@Tony@freshroy, I just got off a couple hour session with MS support.  And seem to have found a work around that has worked for me at the moment.

 

Essentially created a couple more pages in the report, and added in some extra calculated columns, and visuals and republished.  This looks like it has resolved the issue and i have been able to have a successful refresh.

 

Let me know how you go and if that works out for you.

Highlighted
Regular Visitor

Re: Credentials Error on Refreshing

@AnujSikand The workaround you have suggested worked for me. Thanks

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors