Forum Discussion
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, ...
Unfortunately, clearing the cache and restarting Power BI desktop did not solve the problem for me.
The only workaround (manual) was to open the file, hit save, and then close the file. These steps solve the problem every time without fail.
Hi Anonymous
Based on your descriptionif there is a step in your automation process to save a file every time you change data or add data, you may need to add a step to save a file and then refresh the file in your process.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.