Status:
New
Data view not showing any values
Hi, When I am trying to view a table in the data view it is coming up blank, however if I go into the edit query it is bringing up the data and if I go to the filter it is bringing up data. See ...
Even I was facing the same issue. I was using an Excel as source. The Root Cause is the blank cells(rows or columns towards the end).
Fix: Create a new Sheet(Sheet2) in the excel and select the contents(ONLY contents, do not copy the blank rows or columns) from the Sheet1 to Sheet2. Delete the Sheet1. Now save the file and then connect from PBI Desktop to this excel as a new connection and then do the transformations and then close and apply.
This will fix the issue.
Hope it helps !!