Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
@Yuka , 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.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |