Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 56 | |
| 33 | |
| 32 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 65 | |
| 64 | |
| 44 | |
| 30 | |
| 28 |