Forum Discussion
Dynamic M query parameter not working
Hi All, I'm quite new for Power BI. As first, I have created a report to visualize the queue loads of a UiPath process. The query is working, it is gathering the successful / failed counts of items ...
Anonymous , Are you suing direct query source. Because this option is only for Direct Query Sources.
Also, check limitations
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())