cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Neha_19
Frequent Visitor

Dataflow SQL Server Query Advanced Options does not display any data - Table has no rows

Hello,

 

When I connect to SQL Server Query in advanced options in a dataflow, I dont see any data loaded in the table. It just shows the column headers and displays the "table has no rows".

 

However the same SQL query displays data in Power Query editor in Power BI Desktop and also in SSMS.

 

It shows as below screenshow in the Power BI dataflow. Any ideas what could be going wrong ? I have even tried to 'Save and Close' and then tried Refreshing the data, but still it did not bring any data and just says - Table has no rows.

 

Neha_19_0-1614031006618.png

 

Any help would be greatly appreciated.

 

Thanks,

Neha

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @Neha_19 

You used basic SQL Query( Select * from TableName) in your dataflow to get data from SQL Sever and you could only get column headers of your table without data.

Will this issue appear when you in dataflow to get data from other table from SQL Sever by SQL Query?

Your SQL Query is correct. I have a test and it works well.

1.png

Try to click the "Refresh" button in "Home" pane. If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

View solution in original post

1 REPLY 1
RicoZhou
Community Support
Community Support

Hi @Neha_19 

You used basic SQL Query( Select * from TableName) in your dataflow to get data from SQL Sever and you could only get column headers of your table without data.

Will this issue appear when you in dataflow to get data from other table from SQL Sever by SQL Query?

Your SQL Query is correct. I have a test and it works well.

1.png

Try to click the "Refresh" button in "Home" pane. If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!