Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Missing Column error whenever a new Excel File is generated from an automated process

I have a Power BI report (in Power BI Desktop) that uses an Excel spreadsheet generated by an Automated Process as a datasource.   Every time the automated process runs to generate the input file, ...
Need Help
SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

Hi Anonymous 

Does it error at a particular step in the Query Editor? Undefined data types could cause this.

The other thing to try is duplicate the table in the back end.

Delete the original.

Rename the copy to match the original.

Close and Apply.

 

Please Please Please make a back up of the PBIX file before attempting!!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the response, SamWiseOwl .

    It errors out on hitting the Refresh button in Power BI after the new input file is generated from the automated process. This is how it looks like.

    In Power Query, everything looks good till 'Promoted Head'. The error shows up in 'Changed Type'. Here is a screenhot.

     



    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Also, want to add that the manual workaround is simple; open the input file, hit save, and close the input file. The Power BI Report works seamlessly after that. This behaviour repeats everytime.

      I am trying to figure out how to make it work in an automated setup without having to open and save the input file.