Forum Discussion
Data Source Credentials error after Publishing report
Hi,
I get "Data Source Credentials missing" after i published a report via PowerBI Desktop.
Using a SQL username and password (not Windows authentication) to connect to Azure SQL Instance.
Connected datasource as "SQL Server Database" but connecting to Azure SQL Instance. Works correctly with both the internal and external addressese with ports when trying to resolve this issue.
Report works fine from Power BI Desktop and can connect to Azure SQL Instance via SSMS.
3 Replies
BigFlynn , Check the steps used to refresh data on power bi service
https://radacad.com/power-bi-get-data-from-azure-sql-database
Also make sure ips are whitelisted
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-whitelist-urls
Hi BigFlynn ,
Which gateway you are using? Personal mode or standard mode? Please try to remove the data source and reconfigure it.
If not help, could you please share the error message about this issue like some specific screen shots for further discussion?
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
