Publish Dynamic Template report to power bi service

[Anonymous]

Hi All,
I am trying to Publish a dynamic template report to power bi service.
In this case each user can choose parameters like: "from date to last date", "choose category" etc.

However, I understood power bi service don't support this service.

So, 

I will be glad to hear about any other creative solutions.

Tks ,
Dan

[v-jiascu-msft]

Hi Dan,

What would you like to achieve? You can use several Sclier visuals. 

Best Regards,
Dale

[Anonymous]

Hi Dale,
I  want to create template and prevent in memory power bi cloud usage.
In this case all tables are ready  in the server.

Each end user can retrieve data according to his parameters.

So,
I need any recommendation to create template  in power bi cloud 

Dan

[v-jiascu-msft]

Hi Dan,

The parameter is supported in the Power BI Service now in some scenario. For example, the Import mode. You can follow the steps below and give it a try.

1. Create a report with parameters in the Desktop. 

2. Modify the query.

let
    Source = Sql.Database("d***6", "contosoretaildw", [Query="select * from dimproduct where colorname = '" & colors & "';"])
in
    Source

3. Upload it to the Service.

4. Change the parameter in the settings.

What do you mean "prevent in memory"? If you don't like to store the data in the cloud, maybe you can try Direct Query mode.

Best Regards,
Dale