Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Trouble with Odata query with relativepath in PowerQuery

Hello!   For a query I am currently using Odata with the relativepath function. I am trying to pass a date filter through the query but I'm having issues in Powerbi.   Essential I am replacing pa...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Found the issue.

    I had to replace all the + with space. 

     

       #"Added Custom - QUERY" = Table.AddColumn(#"Changed Type", "Custom.1", each Json.Document(Web.Contents("https://xxx/server",
    [
        RelativePath="rest/services/xxx/FeatureServer/0/query",
        Query=[
            where="tijdstip > DATE '2023-06-29'",
            outFields="*",
            resultOffset=[Column1],
            token=access_token1,
            f="json"
        ]
    ]
    ))),

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Found the issue.

I had to replace all the + with space. 

 

   #"Added Custom - QUERY" = Table.AddColumn(#"Changed Type", "Custom.1", each Json.Document(Web.Contents("https://xxx/server",
    [
        RelativePath="rest/services/xxx/FeatureServer/0/query",
        Query=[
            where="tijdstip > DATE '2023-06-29'",
            outFields="*",
            resultOffset=[Column1],
            token=access_token1,
            f="json"
        ]
    ]
    ))),