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.
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!