显示基于用户的报告 [英] Show reports based on user
问题描述
我是PowerBI的新手。我有几家商店。现在,我想为所有商店制作通用报告。所有商店都可以看到相同的报告。但是所有报告的数据都是各自的。这意味着特定的商店可以自己查看数据。我们如何实现呢?
I am new to PowerBI. I have several stores. Now I want to make generic reports for all the stores. All the stores can see same reports. But the data for all the reports would be respective. That means particular store can see the data for itself. How can we achieve that?
推荐答案
我相信您要执行的操作可以通过行级安全性来实现。
I believe what you are trying to do can be achieved with row level security.
https: //docs.microsoft.com/en-us/power-bi/service-admin-rls
基本上,您可以为报表创建角色以进行过滤
Basically, you create roles for your reports which filter the data that is available to be seen by the people or groups that you assign to the roles.
例如,如果您有一家芝加哥商店,则可以创建一个芝加哥角色,它过滤了数据以仅返回数据表的一部分(指定为 Store [City] = Chicago
的过滤器),然后您将给相关人员或来自芝加哥的小组担任该职务,这样他们就可以查看该数据。
E.g., if you had a Chicago store, you could create a "Chicago" role that filtered your data to only return parts of your data table (a filter specified like Store[City] = "Chicago"
) and then you'd give the relevant individuals or groups from Chicago that role so they'd be able to see that data.
这篇关于显示基于用户的报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!