cancel
Showing results for 
Search instead for 
Did you mean: 
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,

View solution in original post

@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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!