Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic URL in Powerquery

Hi, I'm making use of this static connection to an API, this works fine:   = Csv.Document(Web.Contents("https://api.xxxxxx.com/xxxxxxxxxxx/reports/export?format=csv&X-API-KEY=xxxxxxxxxxxxx&start_d...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    I could not modify the URL to achieve your result, maybe you could add an custom column to filter your data:

    if [Date]<=DateTime.Date(DateTime.LocalNow())
then 1 else 0

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

I could not modify the URL to achieve your result, maybe you could add an custom column to filter your data:

if [Date]<=DateTime.Date(DateTime.LocalNow())
then 1 else 0

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks v-danhe-msft , that's a great solution. I tried it out and it works, but I often to continue to have these error messages that make it impossible to pull the data. After trying it with some other data sources it seems it really has to do with the API, it's just not stable enough, so nothing to do about that unfortunately!


Thank you for your help on this!
Bas