Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |