Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've imported an Excel workbook with multiple tabs of data. For some reason two of the tabs are not displaying the data that is in them when loaded into PBI. When I go to 'Edit query' the data is displayed. It's creating an issue when I go to add a new column.
Has anyone had this issue?
Solved! Go to Solution.
The solution was to delete all blank cells in the source excel. Still unsure why it get's loaded in initially with blank rows (at the top) that dont exist in the source excel doc.
The solution was to delete all blank cells in the source excel. Still unsure why it get's loaded in initially with blank rows (at the top) that dont exist in the source excel doc.
Hi @perunt,
Nope, I haven't faced similar issues. Can you please explain more about your scenario?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |