topic Re: Report generation in Developer

Report generation

Anonymous — Mon, 01 Aug 2022 08:05:42 GMT

Hi,

I have a core PBI report with three parameters (country, years, datasource) and I would like to generate the reports for each country (5-6 country) the goal is to have generate the PBI desktop version and then deploy them in the corresponding workspace.

What is the best approach/methods for this?

Re: Report generation

Hariharan_R — Tue, 02 Aug 2022 05:01:57 GMT

Hi @Anonymous

There are different methods to achieve.

Method 1 - You can add country into the dataset, i mean dont filter your data on the country wise. Get all the country data and implement RLS for the country and assign the users to each country (Assign to the roles). This is the recommended option. You will have only one report in your workspace and same can be accessed by different users and they will see only their country data. Maintenance is easy. if you need to do changes in the report then you can do it in one report

Method 2 - For your case, you can have mulitple workspace and deploy the same report on multiple workspace and filter the dataset with specific country. This is not a recommended but I am not sure your exact scenario other than this information. Maintenanace is high.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

Re: Report generation

Anonymous — Tue, 02 Aug 2022 11:08:21 GMT

Thanks @Hariharan_R,

Actually that what I used, but the requriement from the partner to have seperatly generated reports (psychical edition) for each country.

Re: Report generation

Hariharan_R — Tue, 02 Aug 2022 12:55:50 GMT

Hi @Anonymous

The other option would be you can have one dataset with country column added as one of the column with all the country values. deploy the dataset into one of the Power BI workspace.

You need to create Power BI report connecting to that one Power BI dataset and add country in the report level filter. create 6 different reports with one dataset as a source. deploy those report manully to each workspace and provide access.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin