Power Query Not Updating

Question

Hi All&nbsp;Need Your help&nbsp;I have a simple table&nbsp;Excel Sheet 1Job Operating Unit&nbsp;Sum_Net Revenue&nbsp;&nbsp;Right_Sum_Net Revenue&nbsp;&nbsp;Daily Revenue&nbsp;&nbsp;Daily Avg. MTD&nbsp;A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 293,839&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 245,410&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,678,294&nbsp;&nbsp; 1,489,653&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 189&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 153C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 559,429&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 462,800&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51Excel Sheet 2Job OURevenueDaily Avg. MTDManual Column 1Manual Column 2='Daily Rev'!A2='Daily Rev'!D2='Daily Rev'!E229.2425.67='Daily Rev'!A3='Daily Rev'!D3='Daily Rev'!E3198.86221.1='Daily Rev'!A4='Daily Rev'!D4='Daily Rev'!E44846.29&nbsp;Excel Sheet 2&nbsp; is connect to Power BI , but BI desktop not refresh new values in Excel Sheet 2 ( when my Excel Sheet 1 updates via Alteryx)?&nbsp;Any reason why?

vanessafvg · Answer

can you explain what you mean when it updates via alteryx?

so alterx updates sheet 1
power bi is connected to excel 2?

how is this connected, please can you provide more information, its not clear what the problem is.

mussaenda · Answer

Is your Excel&nbsp; sheet 2 connected to a Live dataset in Power BI where the Excel sheet 1 is used?
&nbsp;

anonymous · Answer

Basically sheet 2 is connected to Sheet 1 via a formulas

vanessafvg · Answer

is alteryx updating at the same time you are importing it in, or have you validated that it has updated at the time you are trying to import the data in?

anonymous · Answer

yes i have validated excel has updated, but values are not reflected in BI

Forum Discussion

Power Query Not Updating

8 Replies

Related content

Power Query not Updating after changing source

Power Query dates

Data transform using power query

ayuda en power query

How to update all Queries in Power Query Editor

Job Operating Unit	Sum_Net Revenue	Right_Sum_Net Revenue	Daily Revenue	Daily Avg. MTD
A	293,839	245,410	48	27
B	1,678,294	1,489,653	189	153
C	559,429	462,800	97	51

Job OU	Revenue	Daily Avg. MTD	Manual Column 1	Manual Column 2
='Daily Rev'!A2	='Daily Rev'!D2	='Daily Rev'!E2	29.24	25.67
='Daily Rev'!A3	='Daily Rev'!D3	='Daily Rev'!E3	198.86	221.1
='Daily Rev'!A4	='Daily Rev'!D4	='Daily Rev'!E4	48	46.29