Forum Discussion
Why does my data not shown when loaded onto PBI?
Hi all,
Need your help to troubleshoot for me this particular issue I'm facing...
I loaded an Excel workbook onto my existing PBI by clicking "Excel Workbook" and then "Load".
The data was loaded but it became invisible like this below.
However, when i click "Edit Query" the data is fully shown in this tab.
Why is that
Hi amitchandak,
Thanks for the tip. I realised there were extra empty rows when it was copied and pasted in Excel. Deleted that and it solved the problem.
2 Replies
- amitchandak
Super User
Anonymous , I doubt empty rows also got loaded. in power query remove empty rows and then try
Power Query Remove Empty/Duplicate rows: https://youtu.be/Hk8QtBfcm6k
Hi amitchandak,
Thanks for the tip. I realised there were extra empty rows when it was copied and pasted in Excel. Deleted that and it solved the problem.
