Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to refresh the dataset which is connected to SQL server database. I am getting below 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.
Thanks in advance
Hi @Kavya123 ,
Have you added other data sources?If so,Please go to Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I hope you are connecting your SQL Server on-prem. You need to configure the gateway data source for your SQL server and map the gateway data source under 'Gateway Connection' dataset settings.
Usually Admin will have access to gateways.
Refer - https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources
Thanks
Hari
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |