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

Basically sheet 2 is connected to Sheet 1 via a formulas

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago
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'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)