Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

"This table is empty." - When connecting to SQL Table

I am having issues connecting to a table using the 'Get Data > SQL Server Database'

I use this DB with other reporting software and don't seem to have any issue.  However when I try to import the data I recieve a blank table with the message 'This Table is empty.'

 

I have tried Direct Query and Import and it returns the same information.  Smaller tables show some information but it is not complete information.

 

Any ideas would be appreciated.

 

Need Help

2 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi Anonymous,

     

    In your scenario, have you tried to use SQL query directly to load the data? If not, I would suggest you to try that first to verify if the issue persists. 

     

     

    By the way, since you can get the right data with other reporting software. Please make sure you are using the same credential when connecting SQL Server in Power BI.

     

    And also please check that if your account has view definition permission on the table in SQL Server. Go to Files>Options and settings>Data source settings, select Global permissions, delete any existing SQL Server data sources and then connnect to your SQL Server from Power BI Desktop.

     

     

    Thanks,
    Xi Jin.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you for the reply,  I was able to start creating reports by building a SQL query. 

      I find it odd that we are having a similiar issue with Business Objects pulling and previewing from the same table.  Do you know any security settings that might need to be enabled/disabled to get security working correctly?