Forum Discussion
Adding New table in Existing source , how to import this table in our report
I have created one Power BI report , in which I used sharepoint connection as in web , suddenly user has added one new table in that excel file , how to fetch that table in Power BI to show the table data in report.
Thank you very much lbendlin for your prompt reply.
As lbendlin said. Here is some information I want to share with you:
To get the new table from the Excel file in SharePoint and display it in the Power BI report, you can try the following:
Launch Power BI Desktop where you created the report.
Go to the Home tab and click Transform Data to open the Power Query Editor.
In the Power Query Editor, find your SharePoint connection. Right-click it and select Refresh to update the list of available tables in the Excel file.
After refreshing, the new table should appear in the list of available tables. Select the new table and click Load to import it into Power BI.
Save the updated report.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- lbendlin
Super User
Power Query does not support dynamic adding of sources. All queries (partitions) must be present in the Power BI desktop PBIX.
You might be able to do it programmatically with CI/CD, TMDL and the PBIP format.
Thank you very much lbendlin for your prompt reply.
As lbendlin said. Here is some information I want to share with you:
To get the new table from the Excel file in SharePoint and display it in the Power BI report, you can try the following:
Launch Power BI Desktop where you created the report.
Go to the Home tab and click Transform Data to open the Power Query Editor.
In the Power Query Editor, find your SharePoint connection. Right-click it and select Refresh to update the list of available tables in the Excel file.
After refreshing, the new table should appear in the list of available tables. Select the new table and click Load to import it into Power BI.
Save the updated report.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
