Forum Discussion
1/3 databases from SQL is throwing error when I import in Power BI
1/3 SQL databases is throwing an error when I import in Powert BI. However, everthing works when I use SSMS, I can write and connect with all three databases without issues. Below is the error me...
Hi Anonymous ,
As you mentioned in SSMS, you can connect to the Azure SQL fine. In Power BI desktop, do you use the same credential to get data?
Please go to the Data Source Settings, find the connection which points to this Azure SQL server, then clear it's credential. Then get data from the Azure SQL, enter the same name as you used in SSMS.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.