Forum Discussion
How to create a filter that controls the DirectQuery directly?
I have a failry large dataset that I am using DirectQuery for. I want to summarize the data to just the results so that the DirectQuery works efficiently. Example: let startTime = datetime(202...
Hi,
Thanks for the solution lbendlin provided, and i want to offer some more information for user to refer to.
hello Anonymous , based in your description, you can use the dynamic paramater in power query, you can refer to the following link about it.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.