Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

PBI - all data loaded are null

Hi   I have loaded data from folder consisting 4 excel files. The column titles are the same. After several changes, except for sample file, the others showed null when loading to PBI. let ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank Greg for very helpful. I tried, but still can not fix the issue. 

    I loaded the PBI from the begining and re-build the dashboard. All are good.

    Anyway, thanks for your help, as always.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Somebody else just recently had this issue, the problem turned out to be an extra space in one of their column headers. It's almost guaranteed that the file formats are different in some way. What happens if you use a different sample file? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Greg_Deckler  Thanks Greg. I have copied the title column to other files to ensure they are the same.

    Also, I have tried to change sample file as your advice, the issue is the same - sample file is okay while others are null.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      Anonymous So do you really have this same column in every file?

      #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers",{{"Speaker data 2021.xlsx", "Source.Name"}}),

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Greg_Deckler  I am pretty sure that I have the same columns in every file, as I did copy the column title from sample file to others.

        Additionally, when I run a new PBI file, all data sources are normally loaded. Just current PBI file mess up