Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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)
Below for example one of the teams that have the column working as intended:
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!
Solved! Go to Solution.
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.
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.
@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.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
83 | |
78 | |
54 | |
39 | |
35 |
User | Count |
---|---|
98 | |
80 | |
50 | |
48 | |
48 |