Forum Discussion
Database Not Showing In Power BI But Is Showing In Excel
Hi Alex95 ,
It seems that you have probelms when you get data from SQL Servere Database in Power BI.
Firstly, please check if you have installed the latest version of Power BI Desktop 2.67.5404.581.
In addition, based on your error message, it seems that error should be caused by your credential.
Normally, when we get data with SQL Server Database connector, we should use Database credential and type in the username and password which could sign in when you open the database.
Best Regards,
Cherry
Hi Alex95 ,
It seems that you have probelms when you get data from SQL Servere Database in Power BI.
Firstly, please check if you have installed the latest version of Power BI Desktop 2.67.5404.581.
In addition, based on your error message, it seems that error should be caused by your credential.
Normally, when we get data with SQL Server Database connector, we should use Database credential and type in the username and password which could sign in when you open the database.
Best Regards,
Cherry
- Hi Cherry, Thanks for the response. I was on a PowerBI version running off the App Store which was also a March 2019 release but I downloaded the latest version as you suggested which wasn't on the app store and it seems to have worked with my Windows credentials. It seems to be displaying all the relevant tables and the database is showing. Not sure why it wasn't working before but it's great that it's working now. Thanks for your help and time! Alex
