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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.