Data Source Credentials error after Publishing report

[BigFlynn]

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.

[v-yingjl]

Hi @BigFlynn ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

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 Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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