Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
i have a report includeing 2 data sources - sql DB and an Excel file.
when i am trying to refresh the data or share my report with other people in my oganization i get this error:
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-D-PRIMARY-redirect.analysis.windows.net
Activity ID: d06055c9-41bc-4967-9f10-924c42c7c191
Request ID: 81d6ebb3-1305-29b1-245f-474ff3842867
Time: 2021-11-03 11:40:26Z
I tried to delete the dataset from power bi and then reload it again from Desktop,
thanks for the help!
Solved! Go to Solution.
Instead of the datasources having credentials in the service, also in the settings, can you check the gateway connection? If you connect to the datasource and create the report in Power BI desktop and then publish to the service, sources like Excel and SQL will have to be bound to a gateway.
its disable for me, do you know why?
Instead of the datasources having credentials in the service, also in the settings, can you check the gateway connection? If you connect to the datasource and create the report in Power BI desktop and then publish to the service, sources like Excel and SQL will have to be bound to a gateway.
but now when i shared the report people cant open it and get this:
This error message is telling you to add credentials for datasources on your dataset (in the Power BI Service) for the report that you published.
To do this, go to the workspace where the report is published. For the dataset (not the report itself), click the three dots and choose Settings. Then go to Datasource Credentials and update each item listed.