Forum Discussion

Rose__123's avatar
Rose__123
Helper II
4 years ago
Solved

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? 

Need Help
  • na12063's avatar
    na12063
    4 years ago

    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,

4 Replies

  • na12063's avatar
    na12063
    Resolver I
    4 years ago

    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,

    • Rose__123's avatar
      Rose__123
      Helper II
      4 years ago

      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?

       

  • na12063's avatar
    na12063
    Resolver I
    4 years ago

    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,

    • Rose__123's avatar
      Rose__123
      Helper II
      4 years ago

      na12063 It almost worked šŸ™‚ I was able to update the credentials, but when I try to update I get this error: