Way to show live and data within specific date range to Power BI Report

[ismaan1998]

Hi Team,

I am looking for a way to show live data and data within a specific date range to Power BI Report.

What we tried -

1. Copied the custom query from TSI
2. Connected to Power BI
3. Added query parameters in Power BI Desktop for start and end date.

let
//create variables for start and end times
start = DateTime.ToText(StartDateTime),
end = DateTime.ToText(EndDateTime),

 

queryPart1 = "{""storeType"":""WarmStore"",""isSearchSpanRelative"":true,""clientDataType"":""RDX_20200713_Q"",""environmentFqdn"":""someid.env.timeseries.azure.com"",
        ""queries"":[
            {""getEvents"":
            {""searchSpan"":
            {""from"":""",
queryPart2 = start,
queryPart3 = """,""to"":""",
queryPart4 = end,
queryPart5 = """},",
queryPart6 = """timeSeriesId"":[""edgedevicename"",""sensorname""],""take"":250000}}]}",
//combine individual sections of query into one
    finalQuery = Text.Combine({queryPart1,queryPart2,queryPart3,queryPart4,queryPart5,queryPart6}),
    Source = AzureTimeSeriesInsights.Contents([JsonPayload = finalQuery])
in
    Source

4. Got the live data on Power BI Desktop after refreshing the queries.
5. We're also able to get the data for specific date ranges using Edit parameters

Problem

1. It only works when we're using Power BI Desktop, We want to change the query parameters from the published Report.
2. We've followed the Power BI Video but was not able to see the option for binding the parameter to any column as shown in the image below -
   

Question -

Does Power BI support m query parameters for TSI Connector? if not, are there any recommendations from Microsoft to solve the problem mentioned above?

Thanks.