Change source ( add a new column). Error : table is empty

Hi Anonymous 

It may be unnecessary to modify the source step. Based on my test, after I added a column to the table in Excel file and clicked on Refresh Preview in Power Query Editor, the new column displayed in the data preview in Power Query Editor. And after I applied the changes, the new column's data was loaded into the model. 

How did you change the source step in Power Query Editor? Can you change it back to its original codes? If not possible, you could create a new query and connect to the same Excel file to check if this error occurs in the new query. If not, you could open Advanced Editor to get the new query's M codes. Copy the Source step and Navigation step if any. Then open your original query's Advanced Editor, paste the codes to replace its old corresponding steps. 

Reference:

https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.