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

Data not showing in Table preview

I'm having issue with a table that I'm pulling from SQL showing data. When I try to preview the data only the column headers show but if I go to Edit Queries the data header and data shows. Does anyone know how I can get this data to show?

15 REPLIES 15
jharv9 Frequent Visitor
Frequent Visitor

Data not showing in Table preview

I'm having issue with a table that I'm pulling from SQL showing data. When I try to preview the data only the column headers show but if I go to Edit Queries the data header and data shows. Does anyone know how I can get this data to show?

jharv9 Frequent Visitor
Frequent Visitor

Data not showing in Table preview

I'm having issue with a table that I'm pulling from SQL showing data. When I try to preview the data only the column headers show but if I go to Edit Queries the data header and data shows. Does anyone know how I can get this data to show?

Super User
Super User

Re: Data not showing in Table preview

not sure undestood your question, can you share screen shot?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






Super User
Super User

Re: Data not showing in Table preview

Cool,

 

are you using Direct Query mode or Import mode ?

 

anyhow close the file and reopen it again and check.

 

lt me know

Super User
Super User

Re: Data not showing in Table preview

Cool,

 

are you using Direct Query mode or Import mode ?

 

anyhow close the file and reopen it again and check.

 

lt me know

Super User
Super User

Re: Data not showing in Table preview

@jharv9 What version of the Desktop are you running? I have no issues with (Version: 2.41.4581.361 64-bit (November 2016))

Near SE WI? Join our PUG MSBIWI
jharv9 Frequent Visitor
Frequent Visitor

Re: Data not showing in Table preview

PowerBI Data Issue.PNGData preview (Data doesn't show)PowerBI Data Issue2.PNGQuery Editor (Data shows)

 

jharv9 Frequent Visitor
Frequent Visitor

Re: Data not showing in Table preview

The same. 2.41.4581.361 64-bit (November, 2016)

Super User
Super User

Re: Data not showing in Table preview

@jharv9 I assume you are hitting close and apply in the query editor, what happens when you are on the data tab -> right click the table -> and "refresh data"? Does the data populate, or this just stays blank?

Are you mixing data sources in your PBIX? (Not that this should affect anything, just trying to figure out why it isn't presenting)

Near SE WI? Join our PUG MSBIWI