Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
Solved! Go to 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.
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.
Thanks it was mistake in array in excel and create a new query. It solve problem