Re: Data not showing in Table preview

jharv9 · ‎01-05-2017

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?

megfar · ‎10-18-2017

I am also having the same issue, importing data from a small table (19 columns, 28 rows) in Excel. It worked correctly previously and it's currently working with similar tables from the same Excel file. Have tried deleting and reimporting, repairing the Desktop install (64-bit 2.51 - Oct 2017 updates), rebooting, saving/closing/opening, et al. Still no luck.

AprilD · ‎02-23-2017

Has anyone resolved this? I'm encountering it now. I'm using 64-bit. My other table composed of 17k rows, but they are visible. My other table composed of 3k rows only but data is invisible on Table preview.

Your help would be highly appreciated. Thank you.

dosansil · ‎08-30-2017

I'm looking for an answer too.

megfar · ‎10-18-2017

I am having the same issue with a very small table (28 rows, 19 columns), importing from an Excel file. It worked before and has now stopped working. I've deleted the table and re-imported (many times), repaired my install (64 bit 2.51 - Oct 2017 updates), multiple reboots, etc. Still no luck 😞

Anonymous · ‎01-06-2017

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

jharv9 · ‎01-06-2017

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

Anonymous · ‎01-06-2017

@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)

jharv9 · ‎01-06-2017

When I try to refresh data

Anonymous · ‎01-06-2017

@jharv9 See if this post helps out.

Relevant post by @Sreekanth

"I am able to resolve the issue by adding the value in advanced options of edit queries as mentioned in below. Edit Query->Click on Source->Properties and in advanced options mention the value (number of minutes) it can wait to run the query. Please vote if it helps you ."

I'm guessing your data set is large, and the timeout needs to be increased.

Baskar · ‎01-05-2017

Cool,

are you using Direct Query mode or Import mode ?

anyhow close the file and reopen it again and check.

lt me know

Baskar · ‎01-05-2017

Cool,

are you using Direct Query mode or Import mode ?

anyhow close the file and reopen it again and check.

lt me know

jharv9 · ‎01-05-2017

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 · ‎01-05-2017

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?

parry2k · ‎01-05-2017

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.