Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
riadorra
Helper II
Helper II

Blank Table error

‎11-06-2017 08:35 AM

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

Labels:
Message 1 of 4
10,171 Views
1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

‎11-06-2017 10:13 AM

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.

Specializing in Power Query Formula Language (M)

View solution in original post

Message 2 of 4
11,529 Views
3 REPLIES 3
MarcelBeug
Community Champion
Community Champion

‎11-06-2017 10:13 AM

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.

Specializing in Power Query Formula Language (M)
Message 2 of 4
11,530 Views
Anonymous
Not applicable
In response to MarcelBeug

‎12-26-2022 06:37 AM

If the option 2 is the case. That can produce some kind of errors in the report?

 

 

Message 4 of 4
2,357 Views
0
riadorra
Helper II
Helper II
In response to MarcelBeug

‎11-06-2017 12:03 PM

Hi Marcel,

thank you very much.

There was a lot of blank rows ....

 

best regards

Riad

Message 3 of 4
10,158 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All