Forum Discussion
Helper IIIRefresh all pages from excel
Hi Sonyat810
Here are some steps for your reference:
In Power BI Desktop, go to the "Home" tab and click "Refresh." This will refresh all the data sources in your report. If the new column doesn't appear, try closing and reopening Power BI Desktop and then refreshing again.
Ensure that your Excel file is correctly set up as a data source in Power BI. Go to the Power BI Desktop, click on "Transform Data," and then "Data Source Settings." Verify that the path to your Excel file is correct and that the file is accessible.
Check the query dependencies, sometimes, Power BI might not recognize changes in the data source if there are dependencies in your queries. Go to "Transform Data" and check the query dependencies to ensure that the new column is included in the data model.
If you are using Power BI Service, you might need to update the schema. Open the report in Power BI Desktop, refresh the data, and then republish the report to the Power BI Service.
Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution SageHello Sonyat810 ,
If new rows are added to the existing page then Power BI can refresh and show that data. But if new page is added then Power BI dont pick that new page directly. Reason being each page or sheet in excel is a table in power BI. So Power BI dont pick new table automatically.
If you want new pages need to be picked automatically, then you have to use either functions or parameters in Power Query Editor.
You can refer below link. It may help you:
Solved: select automatically all the sheets of an excel fi... - Microsoft Fabric Community
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
