Forum Discussion
Same report for several countries
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,
Super UserHi. 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,