March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello what about community
I have the following problem. From the table view in power bi it shows that the rows of one of my tables are completely blank. You don't see any data in the table. Whether column titles are displayed. However, the table does have information that appears correctly in Power Query and from Power BI the visualizations are correctly assembled. My table doesn't contain blank rows. The data source is an Excel file.
If from Power Query I delete the "changed type" step (due to the change of data type) if all the information appears in the power bi table. This step was automatic power query. However, it doesn't help me to delete this step since I need the numeric values, and when I delete the step everything goes to text. Does anyone know how to fix this problem?
I attach a photo of how it looks in white.
Hello! I have the same problem, were you able to solve it?
In my particular case it was not fixed when closing and opening the file. I tried it on different machines and have the same problem.
If you use filters in that view, do values pop-up or everything is coming up as blank?
Proud to be a Super User!
Sure enough, apl apply filters the data appeared. It looks like he's adding a bunch of blank rows that don't exist in the original file. These blank rows also don't exist from the Power By. Any idea why this happens?
I would need to check the applied steps in the queries to properly answer what happened.
Proud to be a Super User!
I've seen that issue myself several times and as long as I have data on my visuals it doesn't concern me. Usually it disappears if you close the Power BI file and open it again. I think it has to do more with RAM possibly being saturated.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
87 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |