Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I have a dataset that contains data about 10 different countries published in the service.
However, I would like to create individual reports for each country which would ultimately be connected to one dataset so that one refresh is needed.
I was able to add a "country" parameter to the initial dataset but all it does is filter the source dataset to one country.
How can I achieve this?
Thank you
Solved! Go to Solution.
Hi, @RogerSteinberg
A template file contains only the query definitions, data model and reports, but not the data. When opening a pbit file the user can enter parameter values. Then only the data matching these query parameters is loaded.
Using template to create reports will create several datasets (Although they are from the same datasource).
So if you want to create a new report without creating a new dataset,it is suggest to refer to this post to create a new report by using powerbi dataset and then publish to the same workspace.
Steps are as follows:
connect to datasource -> create report 1->publish to service(dataset1)
->create report2 by using powerbi dataset1->publish to the same workspace(dataset1 ,only create a report2)
->create report3 by using powerbi dataset1->publish to the same workspace(dataset1 ,only create a report3)->...
One disadvantage is that after the model dateset1 is created, if you want to change it, you can only republish it.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @RogerSteinberg
Not very clear.
Is this the result you are looking for ? pbix attached
If it is ,please refer to this post for more details.
Best Regards,
Community Support Team _ Eason
So if I create a template for a user to create several pbix from it, once he/she publishes all the pbix onto the server, wouldn't that create several datasets?
My goal is to have one central dataset for one daily automated refresh and have multiple reports for each individual country.
_____________> Report 1: USA
|
Central Dataset----> Report 2: France
|____________> Report 3: Spain
Hi, @RogerSteinberg
A template file contains only the query definitions, data model and reports, but not the data. When opening a pbit file the user can enter parameter values. Then only the data matching these query parameters is loaded.
Using template to create reports will create several datasets (Although they are from the same datasource).
So if you want to create a new report without creating a new dataset,it is suggest to refer to this post to create a new report by using powerbi dataset and then publish to the same workspace.
Steps are as follows:
connect to datasource -> create report 1->publish to service(dataset1)
->create report2 by using powerbi dataset1->publish to the same workspace(dataset1 ,only create a report2)
->create report3 by using powerbi dataset1->publish to the same workspace(dataset1 ,only create a report3)->...
One disadvantage is that after the model dateset1 is created, if you want to change it, you can only republish it.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.