Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Publish Dynamic Template report to power bi service

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

 

 

 

3 REPLIES 3
v-jiascu-msft
Employee
Employee

Hi Dan,

 

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

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

 

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

Publish-Dynamic-Template-report-to-power-bi-service

3. Upload it to the Service.

4. Change the parameter in the settings.

Publish-Dynamic-Template-report-to-power-bi-service2

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors