Changing of the importing Data time span dynamically.

[HaveeshPerla_1]

Hi Team,

I'm building reports with Azure as DataSource and importing with a set of time range. But if we need to change it as per requirement we need to manually change it in the Kql. 

So my question is is there any dynamic approach to set the importing time span of data dynmaically instead of chaning it manually.

eg: if we are bringing data for 30hours and we are handling data accordingly. but if we need 40 hours other day instead of manually changing in kql can do it dynamically.  Is there any alternative for this.

Regards,

Haveesh

[Anonymous]

HI @HaveeshPerla_1,

What type of data source are you worked? If it allows the query string filter, you can parameterized connection string with query parameters or M query functions. Then these connection string will dynamic changes based on query parameter and M function results.

Regards,

Xiaoxin Sheng

[HaveeshPerla_1]

Hi, 

I'm taking Azure as Database and importing it to PowerBi. Please suggest based on this too.

Regards,

Haveesh