Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Changing of the importing Data time span dynamically.

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.




Community Support
Community Support

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.


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.


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




Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.