a column of data in source table missing in report visual

[SosoH]

Hello,

A column of data is missing in report visual. Anyone know the reason and how to fix it? Thanks.

In the report visual, the data is missing

I checked in "edit query", the data is there

[Ritaf1983]

Hi @SosoH 

It seems like something deal

The problem seems to be related to the relationships between the tables in the model.
It's as if you're pulling something from another table that doesn't exist.

For more details, need to see a sample file.

[SosoH]

Hi Ritaf1983,

I combined five excels and in only one file the column" 12nc" showing the number, the other three showing null:

file "1/01/2023"  has correct data in column "12nc". I filter this date in power bi report, the 12nc is visible.

The other four showing "null". The 12nc for these dates are invisible in power bi report.

I also checked the clomun "12nc" in original excel files and didn't find any difference in format. Not sure why it's showing null.

[Ashish_Mathur · Accepted solution]

Hi,

It looks like a Data type issue.  In all files, ensure that the data type of the 12NC column in text.  If it still does not help, then share the download link of the PBI file.