Forum Discussion
Power BI data shown in Query Editor not shown in table view
I have a strange situation where I was working in the query editor updating some information. I am currently able to see data in the Query Editor. However when I toggle back to the PBI desktop and look for the data in the table view it is blank. I have tried to refresh the data and am still getting the same results.
What am I doing wrong?
3 Replies
- JarroVGIT
Resident Rockstar
Could you share screenshot of Power Query and the tableview on the right hand side of the screen of the PBI Desktop screen? What happens if you drag one of the columns to the canvas and than select that visual and select the Table visual to turn it into a table?
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
JarroVGITThanks for your reply. Obviously I can't snip the full data set but here is a subset. I have filtered by specific contract numbers that represent data in all 3 columns in the QE but are not showing in the PBI table view. When I try to create a visual I am getting 0 because the 12 month average (mins) is showing 0 in the table view however has values in QE.
