Forum Discussion
Same report for several countries
Hello,
I have a desktop report created and I need the same report for 30 countries BUT each with different data source. Only name of the database differs (by the country abreviation). Is there an easy way how to work with such reports in case of a change? For example we decide to add a new page into the report. Do I have to do it for all 30 reports separately or is there a way how to do it less painfully?
I was thinking maybe having one desktop report and then change and clone separate reports based on the country`s database name? But I`m not sure if something like this is even possible...
Thank you very much for any advice.
Barbora
Hi. The best approach is integrating the data. You can store all the 30 country tables in a lakehouse/warehouse in order to work with the tables and build a single table that has a column to differentiate the country. That way you get only one table with Power Bi. You can build one report and configure Row Level Security (RLS) to let each user only see data for the corresponding country.
You could also get the 30 tables in Power Bi disabling their load. Append all them together with a new column to differentiate the country. It might be low at Power BI, that's why I said before to do it in a lake or warehouse, but it would work.
That's the way to build one time something that would be different data for each user.
I hope that helps,
1 Reply
Hi. The best approach is integrating the data. You can store all the 30 country tables in a lakehouse/warehouse in order to work with the tables and build a single table that has a column to differentiate the country. That way you get only one table with Power Bi. You can build one report and configure Row Level Security (RLS) to let each user only see data for the corresponding country.
You could also get the 30 tables in Power Bi disabling their load. Append all them together with a new column to differentiate the country. It might be low at Power BI, that's why I said before to do it in a lake or warehouse, but it would work.
That's the way to build one time something that would be different data for each user.
I hope that helps,