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

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.

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.