Forum Discussion

catrin's avatar
catrin
New Member
8 years ago
Solved

Columns removed from excel file and report not loading

Hello, I am very new to PowerBI and so looking for some help.    I set up a report with lots of graphs, tables etc, with calculated columns and measures in it. My excel source file structure has ch...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi catrin,

     

    To what I can understand you are having missing columns from your query editor steps, the solution is going step by step and check where it gives error and then deleting the column name from that specific step.

     

    Can you share some sample to help you better?

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi catrin,

 

To what I can understand you are having missing columns from your query editor steps, the solution is going step by step and check where it gives error and then deleting the column name from that specific step.

 

Can you share some sample to help you better?

 

Regards,

MFelix

catrin's avatar
catrin
New Member
8 years ago

Sorry for delayed reply. I figured it out in the end by going into the Edit Queries, then Advanced Editor and removing the columns from the text there. Hopefully that's what you meant, but if not, it worked!!