根据当前用户筛选 Power BI 报告 [英] Filter Power BI report based on current user

问题描述

我们目前正在为我们公司开发 Power BI 仪表板 (Office 365)，并希望根据当前用户的偏好定制仪表板上的信息.

We're currently developing a Power BI Dashboard (Office 365) for our company and would like to tailor the information on the dashboard based on the current user's preferences.

我们公司有多个部门和子部门，所以把每个部门的数据都展示给所有用户会适得其反.

Our company has multiple departments and sub-departments, so to display every department's figures to all users would be counter-productive.

例如，如果 Bob 在欧洲销售 - 他只会看到欧洲销售，而 Sue 只会看到美国销售.

For example if Bob is in Sales for Europe - he'll only see European sales, while Sue will only see Sales for America.

PowerBI 是否可以识别当前用户，然后根据用户的偏好(存储在 SQL 表中)从 SSAS 多维数据集中过滤结果?

Is there a way PowerBI can identify the current user and then filter the results from the SSAS cube based on the user's preferences (which are store on a SQL table)?

我想这可以通过 M Query 语句完成，但我不确定如何使用它来过滤结果.

I would imagine this could be done via the M Query statement, but I'm unsure on how to use it to filter the results.

推荐答案

听起来您已经有了 SSAS 多维数据集?多维?首先在 SSAS 中设置基于角色的安全性.如果你有定义谁应该看到什么的 SQL 表(或者在你的情况下这听起来像是用户偏好，所以谁想要看到什么)然后使用动态安全性:http://hccmsbi.blogspot.com/2007/08/implementing-user-specific-security-in.html

It sounds like you have an SSAS cube already? Multidimensional? First setup role based security in SSAS. If you have SQL tables that define who should see what (or in your case it sounds like a user preference, so who wants to see what) then use dynamic security: http://hccmsbi.blogspot.com/2007/08/implementing-user-specific-security-in.html

然后安装 Power BI Enterprise Gateway:https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/

Then install the Power BI Enterprise Gateway: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/

然后将其连接到 SSAS:https://powerbi.microsoft.com/en-我们/文档/powerbi-gateway-enterprise-manage-ssas/

Then connect it to SSAS: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/

您将需要 SQL Server 2012 SP1 CU4 或更高版本的 SSAS.您将需要企业版或 BI 版 SSAS.每个用户都需要一个 Power BI Pro 许可证.

You will need SQL Server 2012 SP1 CU4 or later on SSAS. You will need Enterprise or BI Edition SSAS. And you will need a Power BI Pro license for each user.

这篇关于根据当前用户筛选 Power BI 报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！