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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Bullmasta
Frequent Visitor

Power BI showing Null 99% and Excel Table have data

Hi all, 

 

Im strugling to find the reason in why a column of some table is showing mostly blanks when I can see data in my source. 

 

For context, i have 3 files, for 3 different teams. And all files have same table inside. 
In PowerBI i load them all, and are merged. 

But for some reason, there is a column, that shows data correctly for 2 out fo 3 teams. For 1 team the column shows empty.

When i check the team file, there are 131 rows meeting the conditions, and from those, 45 have actually data in the mentioned column. 

In Power BI, 2 out of 3 teams display column data correctly, but for this last one, out of 131 rows, only 1 appears with data... 

Column is formatted as a date. 

Example below, whenever there is a date in first column, there should be (because there is in Excel) a date in 3rd column. 

(left is PBI vs right Excel)

Bullmasta_1-1696344399553.pngBullmasta_2-1696344436349.png

Below for example one of the teams that have the column working as intended:

Bullmasta_3-1696344868207.pngBullmasta_4-1696344876622.png

 

I am not sure what else i could share that could help give a solution. For me the weirdest thing is that if in the power Query editor y add a step and filter, it will show me data for all teams except the one i mention with no data... which makes no sense to me. 

 

Hope it makes sense what i tried to explain, thanks in advance!

 

 

 

 

1 ACCEPTED SOLUTION
Bullmasta
Frequent Visitor

nevermind, after some checks in the 3 excel files, noticed that 1 of them had column name typo. For some reason PBI didn't detected the change on the excel by someone else and never gave the error of column not found. 

After making sure all 3 columns had same name, data shows as intended. 

 

For whoever checks this post in the futue: be sure that column headers from tables (if merging more than one file table into 1) have exact same name. 

View solution in original post

3 REPLIES 3
Bullmasta
Frequent Visitor

nevermind, after some checks in the 3 excel files, noticed that 1 of them had column name typo. For some reason PBI didn't detected the change on the excel by someone else and never gave the error of column not found. 

After making sure all 3 columns had same name, data shows as intended. 

 

For whoever checks this post in the futue: be sure that column headers from tables (if merging more than one file table into 1) have exact same name. 

amitchandak
Super User
Super User

@Bullmasta , I Hope there are no hidden rows in the Excel; in the first screenshot.

 

Also a rownumber or index and load and try. Usually, order of load is the same. but just check using the row number.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

well yes, there are hidden rows. The excel screenshot is meant to be same filter that i applied in the Power query so i could show how it shows in PBI vs same lines in Excel. 
as you can see, if i filter team A, i get no dates ... and if i filter team B, i get dates... so it makes no sense to me, when both are having dates... if that makes sense. 

 

@amitchandak  What do you mean with rownumber or index and load? my pbi knowledge is not very advance i may add ... 🙂 thanks!

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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