Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power Query Not Updating

Hi All   Need Your help   I have a simple table   Excel Sheet 1 Job Operating Unit  Sum_Net Revenue   Right_Sum_Net Revenue   Daily Revenue   Daily Avg. MTD  A                     2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes I did save

 

when i open excel, I see values changed, but power query still displays OLD values.

 

if I connect to sheet 1 , i have no problems

 

when i connect to Sheet 2 ( which has simple cell linking formulas and additional columns) power bi does not update

 

so i am trying to understand how Power Bi Treats excel file with formulas

 

Additional info

Sheet 1 is constanly overwritten by Alteryx ( as and when i run it)

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous , 

When Power BI imports data from an Excel file with formulas, it will bring in columns of values calculated by the formulas. 

I use your sample data and formulas in a regular Excel workbook without using Alteryx to test this. When I click either Refresh Preview in Power Query Editor or Refresh button in Power BI Desktop, I can always see the latest data from both sheet 1 and sheet 2. Everything works well. So I'm not sure if Alteryx will have some influence on this?