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.
Super UserYou 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