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
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
Hi Dan,
What would you like to achieve? You can use several Sclier visuals.
Best Regards,
Dale
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
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
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.