Multiple versions of same report with different parameters

[blhowie66]

Hi all,

I have a report that I've created that I want to set up such that I can have multiple versions where I can change one of the parameters that the report runs with so that one version runs for one location (location is the parameter), one runs for another, etc.  Right now I've got multiple versions of the actual report set up in their own pbix files to accomplish this.  Then I've got individual dashboards set up by location and I publish the appropriate pbix file to the appropriate dashboard.  

I'm thinking that there has to be a more elegant, intuitive way to do this besides creating a new pbix file for every location I want to do this for.  Right now there are 3 reports and 2 locations so I have 6 separate pbix files set up.  Anyone have any thoughts on a better way to do this?  Any and all suggestions are appreciated.  Thanks!

Bill

[v-yuta-msft · Accepted solution]

@blhowie66 ,

No very clear about "version" you mentioned. Generally, if you need to create different reports, you can firstly create a power bi template file(.pbit) and then your teammate can use this template report to create their own report and publish to a same workspace(I think maybe "location" means workspace?) or different workspace. 

Community Support Team _ Jimmy Tao

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

[leed]

Hi @blhowie66 

How about loading all the data from different location into only 1 pbix file - with a new key column that indicates where the location is (let's say table A)

Then add a new table B with 2 columns (manage from an Excel file / Enter data directly etc.) that contains :

1 column for the location 

1 column for the AD user group that can see this location

=> Link table B to table A and apply a RLS on top of table B.

Very interesting question, wait for another feedbacks 🙂

DA