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
Rose__123
Helper II
Helper II

Error on scheduled refresh

Hi

I have uploaded a report to Power BI web. All its datasets have been collected online through Dynamic 365. In the beginning, I was able to make a scheduled refresh, but today it makes this error:


Last refresh failed: Thu Sep 23 2021 14:15:53 GMT+0200 (Centraleuropæisk sommertid)
Scheduled refresh has been disabled.

Data source error: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.
Cluster URI:WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net



I am not able to update the credentials, but I don't understand why I suddenly should do so and not before? 

Rose__123_0-1632404598018.png

1 ACCEPTED SOLUTION
na12063
Helper I
Helper I

Hi @Rose__123,

 

Do this:  On Power BI Desktop -> Transform Data -> Advanced Editor -> 

FROM: 
let
Source = Web.BrowserContents

Change it TO:
let
Source = Web.Contents

 

Save it and publish it and let me know if this will solve your issue.

Regards,

View solution in original post

4 REPLIES 4
na12063
Helper I
Helper I

Hi @Rose__123,

 

Do this:  On Power BI Desktop -> Transform Data -> Advanced Editor -> 

FROM: 
let
Source = Web.BrowserContents

Change it TO:
let
Source = Web.Contents

 

Save it and publish it and let me know if this will solve your issue.

Regards,

@na12063 It almost worked 🙂 I was able to update the credentials, but when I try to update I get this error:

Rose__123_0-1632488083547.png

 

na12063
Helper I
Helper I

Hi @Rose__123 ,

 

Open Power BI Desktop file > Transform data > Data source settings > select your data sources >Edit Permissions.. make sure all datasources are connected then re-publish the report and should work. If you using Gateway > Gateway connection > make sure you select the right connection for your datasource. 
Hope this helps!

Regards,

@na12063 thank you for your reply! I tried that now, but it doesn't seem to work. What is the purpose of the privacy level in this context?

Rose__123_0-1632413944963.png

 

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