Forum Discussion

SosoH's avatar
SosoH
New Member
3 years ago
Solved

a column of data in source table missing in report visual

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

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      SosoH
      New Member
      3 years ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        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.