-1

I have one dashboards one with all data from all countries, and I would like one single dashboard for each country reusing the previous dataset. I would like to do that to minimize the space needed in cloud for those dashboards. Also there is users that only should have access to data to each own country. I tried to create a parameter to filter by country but it is not allowed when I reuse a data set as data source.

Could you please help me to find a way to reuse dataset filtering by country in order to minimize the resources needed? Thanks in advance

TamaraIria
  • 1

1 Answers1

0

Either use Row-level security to define which rows should be visible to the current user, or make separate reports for each country and share the data source between them. If you use Direct Query, there will be single copy of the data. Or you can publish one report with data for all countries to the cloud, and use it as a data source for the per-country reports.

Andrey Nikolov
  • 12,967
  • 3
  • 20
  • 32