Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Priorr
Frequent Visitor

This table is empty - error

I am having issues connecting to data on an SQL server link whereby using the credentials for a data reader I can see data in some tables but not others.  We have checked individual table permissions and they all tally and are now at a loss.  Has anyone else experienced this issue using PowerBI?  We know there is data in the tables displaying the above error as we can view it using SSMS.

I can have my IT guy give more specific details if needed but any help would be gratefully appreciated as to troubleshooting steps.

Thanks

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @Priorr,

How do you connect to SQL Server database? I assume that you are using Power BI Desktop, if that is the case, as you can view data of tables in SSMS, I would recommend you directly write SQL query in the following screenshot to connect to the problem tables and check if the issue still persists.
2.png


In addition, make sure that you use the same account and credential as SSMS to connect to SQL Server database in Power BI Desktop.
1.PNG

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia,

 

Thanks for the reply (sorry for delay, I have been on holiday!) 

Yes I do use PowerBI desktop to connect.  I just tried connecting directly to the table using an SQL query and it returns data.  But on the overall connection it still does not.

Do you have any further ideas as to why?

 

Thanks again

Richard

Hi @Priorr,

Do you mean that you are able to load data from SQL table to Power BI Desktop when writing T-SQL statement in the following screenshot?
1.png

If that is the case, have you checked that if your account has view definition permission on the table in SQL Server? Also 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.
2.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors