Forum Discussion

Frequent Visitor

2 years ago

Enter Date filter in Power BI Source url

Hi, I have a source API URL: = Json.Document(Web.Contents("https://xyz.com.au/api/", [Query=[ dbtable="statementitems", fundingtype= "2", Authkey = ApiKey, includedeleted = "yes", toprestr...

Need Help

Anonymous

Not applicable

2 years ago

Hi DryMouse555 ,

Please update the codes as below and check if it can return the expected data with specific date range:

let
    Source = Json.Document(Web.Contents("https://xyz.com.au/api/", 
    [
        Query = [
            dbtable = "statementitems",
            fundingtype = "2",
            Authkey = ApiKey,
            includedeleted = "yes",
            toprestrict = "1000000",
            source = "powerBI"
        ]
    ])),
    FilteredData = Table.SelectRows(Source, each [itemdate] >= #date(2024, 6, 1) and [itemdate] <= #date(2026, 6, 1))
in
    FilteredData

Best Regards