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 have validated excel has updated, but values are not reflected in BI

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

Hi Anonymous ,

Did you save your Excel sheet 2 after it was updated? In my testing, Excel sheet 2 is updated automatically when Excel sheet 1 is changed, but the data in power bi desktop which comes from sheet 2 won't refresh until I have saved the Excel file. When you click Refresh button in power bi desktop, it always tries to get data from the last saved file.

 

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

  • 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?