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

[Anonymous]

As source for table ( table1) in power bi i  have excel file( array from list).   On this tables are builder a lot of visuals.

The are columns: name company, date, status, quantity, sales

Now  excel file is changeed: added a new column " rank" . 

Now they are columns: name company, date, status, rank, quantity, sales.

I try to change sourse for table1, but on step source in power query i have error: this table is empty.

Can somebody help with  this mistake?  How i can correctly change a source ( with new column) for table1?

[v-jingzhang · Accepted solution]

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.

[Anonymous]

Thanks it was mistake in array  in excel and create a new query.   It solve problem