Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We are using the NPGSQL 3.2.7 drivers from Github to connect to PostgreSQL from Desktop and through the data gateway. The desktop version works fine, and we have worked through several gateway issues including having old Datasets in our report. Now we are getting the error "Scheduled refresh has been disabled due to at least one data source not having credentials." The one data source that is listed under the data gateway, however, tests fine. It does not show an error.
I am more experienced with SQL Server than with PostgreSQL, so any suggestions for debugging this would be appreciated.
Solved! Go to Solution.
Hi @RandyPgh
Look at the scheduled refresh setting page, confirm an enterprise gateway is selected and the data source credential is correct.
If no abnormal is found, please delete the data source under gateway and re-connect the data source, make sure connection strings of the data source under gateway are same as that in Power BI Desktop
Best Regards
Maggie
Hi @RandyPgh
Look at the scheduled refresh setting page, confirm an enterprise gateway is selected and the data source credential is correct.
If no abnormal is found, please delete the data source under gateway and re-connect the data source, make sure connection strings of the data source under gateway are same as that in Power BI Desktop
Best Regards
Maggie
Thanks, maggie. There were no connection strings, but somehow dropping and recreating the data source within the gateway fixed the issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.