none
Track Changes Power Query - After Refresh RRS feed

  • Question

  • Hi,

    Is there a way to get informed when the value or string of a cell changes after the query was refreshed.

    BR

    Monday, November 3, 2014 9:08 AM

Answers

All replies

  • example:

    I have a json file with two Sites:

    {
    "SiteA": {
    "Color": "blue",
    "Date": "24.12.2014"
    },
    "SiteB": {
    "Color": "red",
    "Date": "25.12.2014"
    }
    }

    after Reload:

    {
    "SiteA": {
    "Color": "green",
    "Date": "24.12.2014"
    },
    "SiteB": {
    "Color": "red",
    "Date": "26.12.2014"
    }
    }

    How can I track that the color of SiteA has changed to green and the Date of SiteB after refreshing?

    BR,

    Bernd


    • Edited by BerndSPL Monday, November 3, 2014 2:01 PM
    Monday, November 3, 2014 2:00 PM
  • Not directly, though if you're filling to Excel you might be able to write a macro to do this.

    Ehren

    Friday, November 14, 2014 10:21 PM
    Owner