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.
Hi,
I am getting a data from excel and when i setelct "data" to visualize the information it appears blank ...
Can anyone help me?
ps: on query editor the table is normal (not blank) ...
Thank you
Riad
Solved! Go to Solution.
Based on your limited information, I can think of 2 possibilities:
1. You have blank values that are sorted somewhere at the bottom in Power Query, and on top in the data view.
2. The actual values don't correspond with the columns data type, e.g. if you have text values in a column with number data type, then these values are visible in Power Query but not after loading into the data model.
Based on your limited information, I can think of 2 possibilities:
1. You have blank values that are sorted somewhere at the bottom in Power Query, and on top in the data view.
2. The actual values don't correspond with the columns data type, e.g. if you have text values in a column with number data type, then these values are visible in Power Query but not after loading into the data model.
If the option 2 is the case. That can produce some kind of errors in the report?
Hi Marcel,
thank you very much.
There was a lot of blank rows ....
best regards
Riad
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |