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! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Baskar Super Contributor
Super Contributor

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

Baskar Super Contributor
Super Contributor

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 Milwaukee Brew City PUG
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 Milwaukee Brew City PUG

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 56 members 1,163 guests
Please welcome our newest community members: