Forum Discussion
Helper IIIRefresh all pages from excel
Power BI isn't refreshing all pages from (Using excel as data source). What can I do to refresh the new page created.
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.
9 Replies
- Kishore_KVN
Solution Sage
Hello 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 CommunityIf this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
- danextian
Super User
You mean a new tab or table in Excel? If you use the folder connector, the transform query created when using the combine and transform feature of Power Query selects a specific table so any other tables with a different name will not be included. If you connected directly to an Excel file, the connetion specifies which table to pull and only that table will be included in the query.
Sonyat810Its actually a new column in Excel I added and created a page in Power BI
- danextian
If you explicitly selected columns in one of the applied steps, newly created column in Excel will be excluded. Click on the wrench on the the applied steps that says Removed Other Columns.
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.
