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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Toll
Helper I
Helper I

Can't refresh dataset in PBI service but can refresh within PBI desktop using same credentials

Hello,

 

My organisational policy made me change my Windows password and since then I am getting the following error when trying to refresh a dataset within Power BI service:

"Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."

 

My report connects to Sharepoint Lists and Web (XML Tables). I can open and refresh via Power BI desktop (using new credentials) but can't refresh when I publish the report.

 

I have re-entered all credentials within Power BI Desktop (Data Source Settings) and tried using Windows account and Organisational account but no luck.

 

I have deleted the dataset (and report) from the service and re-published but that didn't work either.

 

There are no parameters and there are no gateways configured.

5 REPLIES 5
v-jialluo-msft
Community Support
Community Support

Hi @Toll ,

 

Do you need a way to omit steps?

You need to start building the pbix file again, there is currently no good way to omit steps, and calling the previous data may cause the previous problem to persist.

 

Best Regards,

Gallen Luo

v-jialluo-msft
Community Support
Community Support

Hi @Toll ,

 

According to your description, datasets on Power BI Service fail to refresh after changing the Windows password, and republishing doesn't resolve the issue.

It is possible that the PBIX file contains previous credential information. I recommend creating a new Power BI Desktop project, re-fetching the data, and then creating the report.

Then publish to Power BI Service and see if the problem is resolved.

 

Best Regards,

Gallen Luo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-jialluo-msft ,

 

Thank you for the suggestion.

 

Is there a way to re-create the PBIX without starting from the beginning?

I was trying to not start over again if possible 

Shahfaisal
Solution Sage
Solution Sage

Have you tried doing the following in Power BI Service?

 go to this dataset's settings page and enter credentials for all data sources

Yes, it only gives me option for "Anonymous" and "OAuth2" and then I have to select the privacy settings.

 

I have tried all possibly combinations of those settings and nothing works.

 

EDIT: apologies, I should've mentioned in the first post that I had tried that, too.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors