Forum Discussion
Dynamic M query parameter not working
Anonymous , Are you suing direct query source. Because this option is only for Direct Query Sources.
Also, check limitations
- Anonymous5 years agoNot applicable
amitchandak I'm absolutely not sure, but as far I know, direct query is that query type, which does not store the data in the Power BI model, but always querying for it with any load - as I know, the API is directly for that. Isn't it? I'm using the OData Version 4.0 model API for the query, and I'm getting the data always (with authentication, token, etc.) in application/json (in case this is an important information)
And I could not see anything in the limitation which would be fit for my report.
For the "filter" or parameter data, I'm generating a table, - as written in the blog as well - with this command:
StartDateTable = CALENDAR (DATE(2021,1,1), TODAY()) - Anonymous5 years agoNot applicable
amitchandak now I read a bit more after the directquery, but could not find if it is direct or import... but when I have created the blank query as data source. and there I'm using queries like this:
let Path = "/odata/QueueDefinitions?$filter=Name eq '" & in_QueueName & "'", Auth = Json.Document(Web.Contents(BaseUrl, [Headers=[#"Content-Type"="application/json"], Content=Json.FromValue(Credentials), RelativePath="/api/account/authenticate"])), Token = Auth[result], Source = Json.Document(Web.Contents(BaseUrl, [Headers=[Accept="application/json", #"Authorization"="Bearer " & Token], RelativePath=Path])), value = Source[value], ResultRecord = value{0}, ResultId = ResultRecord[Id] in ResultIdSo really not sure, but for me it seems to be direct query.