Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I have started using Odata url links to link Power BI and Excel to MS Dynamics Business Central.
I want to be able to restrict how much data comes over by date. Our Finance data is 6 million + rows and takes a long time to download.
I can restrict the download by adding a ?!filter date to the end of the url, for example ?$filter=<FIELD> gt '2022-10-01' .
This is a fixed date. I would like the Filter date to be a range specfied by user when report is run.
Is it possible to add a user defined date range which the user can change each time it is run ie. 01/10/2022 to 28/10/2022. Thereby restricting the download to relevant dates instead of everything or a hard coded date which never changes?
I hope this makes sense.
Thanks for any help
Pete
Solved! Go to Solution.
Thank you
Hi @PBE ,
Did the lbendlin's answer helped you? If so, please consider marking the most helpful answer as a solution, as this will help people searching the forum for similar questions in the future to find answers more quickly. Thanks in advance!
If the problem is still unresolved, you can continue to add details of the problem below and feel free to contact us.
Best Regards,
Gao
Community Support Team