Add dyinamic range on JSON Web Service

[Anonymous]

Is the any way to add a dynamic range for dates, so the user/admn can define how much date will the report load when is updating 

my URL has a segment where we definethe dates 


from = 2022-01-01
to = 2022-12-31

[selimovd]

Hey @Anonymous ,

you can define a parameter in the report that is passed through to Power Query. This feature is called dynamic M parameter:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

However this currently works with direct query only, so it won't work with a web URL. If the data source would something that supports direct query like a Azure SQL server, this approach would work.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic