Forum Discussion
Data not Showing up
Hi Everyone - Hoping someone can help.
I have been having an issue lately with my data not showing up after I apply changes in the Queryt Editor.
The data will be there to start with, but if I "Enable Load" then decide later that I do in fact need that table to load in, so select Enable Load again, the data does not show up. It loads in the Column names, but it appears as if the tables are empty. Has anyone else had an issue like this? Am I missing something simple?
Thanks for the help!
Refreshing the data was the first thing that I did; that didn't work.
I think it has something to do with the preview features that I had enabled. I disabled them, then tried loading the data in and it worked.
29 Replies
Just try to force the refresh by going to the Data Mode (NOT the "Edit Queries" mode) and right clicking at the TABLE (NOT the general "Refresh" button at Home Menu) and choosing "Refresh" . That should do it.
In my case, user error, but this might help someone else - and remind me when it happens in the future and I forget how I sorted it and google the article again :-)
The Values fields contained a number type column which PBI automatically chooses to "Sum" in the settings of the Values field. Changing the number type column's setting to "Not Summarize" sorted the whole data display for me.
When creating a table, via power query editor , unpivoting, I could not show even a simple table or matrix. Data fields did not show.
Tried "refresh data" of the table: no effect. Removed any preview features and strat up Pbi again: no effect.
Then I removed the relationship between the tables , so the table was not connected at all to any other table: the data became available 😉 !. Then I ensured a correct relationship between my tables and everything worked out fine. (after 2 hours struggling...)
please can you suggest me answer for this i am also not getting data.
I would suggest disabling any preview features that you may have enabled. I'm not sure if it was one specific feature that was causing the issue, but when I disabled all of them, everything went back to normal.
Hope this helps!
Thank you
Hey Anonymous , I am facing the same issue, sometime data shows up after I refresh the table from data view but sometimes it don't work.
Please reply back if you get any proper solution.
Thanks!
hiii,
i faced the same issue, when the data amount is large it occurs, i had many raws of empty data, after removal of those the data became visible. try it!
Refreshing the data was the first thing that I did; that didn't work.
I think it has something to do with the preview features that I had enabled. I disabled them, then tried loading the data in and it worked.
I'm also facing the same issue and tried everything possible.
All of a sudden I'm only getting 5 days of data where I'm querying for 30 days of data.
I even tried with 10 days but no luck.
Someone needs to look into this issue.
cc : cclark01Even data exist, data visualization doesn't show in my dashboarddata existno visualization
Hi every one
When I select the if function, the dex bar does not show the columns that I select
please help me
