Forum Discussion

Alex95's avatar
Alex95
New Member
7 years ago
Solved

Database Not Showing In Power BI But Is Showing In Excel

Hi all, I'm currently having a couple of issues trying to link data from a database in SQL Server to Power BI Desktop. However, I can access all the tables from Excel with no issues at all. I believe ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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

 

Alex95's avatar
Alex95
New Member
7 years ago
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