Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Syndicate_Admin
Administrator
Administrator

Problem with data visualization in "Table View"

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.

Fedemass_0-1716986364593.png

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

Hello! I have the same problem, were you able to solve it?

Syndicate_Admin
Administrator
Administrator

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?





Did I answer your question? Give your kudos and mark my post as a solution!

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.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





ray_aramburo
Super User
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.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.