Refresh all pages from excel

[Sonyat810]

Power BI isn't refreshing all pages from (Using excel as data source). What can I do to refresh the new page created.

[Anonymous · Accepted solution]

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.

[danextian]

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.

[Sonyat810]

Its 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.

[Sonyat810]

I added the column in Excel. Not Power BI

[danextian]

Exactly. If you explicitly selected Column1 and Column2 in the query editor, all other columns before this applied step will be excluded whether they existed or newly added.

[Kishore_KVN]

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 Community

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Sonyat810]

Its not a new table. Its existing. I just added new column

[Sonyat810]

How do I automatically pick pages? I guess I'm confused on that part.