Forum Discussion

VeljkoP98's avatar
VeljkoP98
Frequent Visitor
2 years ago

Empty columns appearing in PowerBi

Hello everyone,   Has anyone of you experienced the problem when i load new data source i get empty Columns, with names Column32, Column33, ... Column107 etc. These are all empty. How can i stop th...
Need Help
Fowmy's avatar
Fowmy
Super User
2 years ago

VeljkoP98 

What is your source data ? is it CSV ?
Ensure you delte unnecessary columns in Power Query

  • VeljkoP98's avatar
    VeljkoP98
    Frequent Visitor
    2 years ago

    It is simple Excel file. 

    I want to be sure that they won't appear when i load new excel file source.

  • VeljkoP98's avatar
    VeljkoP98
    Frequent Visitor
    2 years ago

    It seems that it reads the columns from Excel even after last column that has data, it reads other columns even thou they are empty