The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Greetings
I'm a newbie to Power BI (and way more a power excel user than a developer), and I am trying to build a dashboard that shows user specific data (in this case their utilization, their billed hours, etc.).
Is there any way to build a report/dashboard that only displays that user relevant data?
Thanks
Solved! Go to Solution.
Yes, row-level data access works with the SSAS MD. But right now you can not publish reports based on SSAS MD to the Power BI Web-Service (but I guess it will come at some point in time).
// In Fact the Row-level based security also works with Azure SQL DB and also very likely soon with SQL Server 2016 (on-prem or IaaS).
@FlyingTuga You can start with SSAS Tabular modeling to have row level access to data. You can check link here & here
Is it possible with multidimensional model as well?
Yes, row-level data access works with the SSAS MD. But right now you can not publish reports based on SSAS MD to the Power BI Web-Service (but I guess it will come at some point in time).
// In Fact the Row-level based security also works with Azure SQL DB and also very likely soon with SQL Server 2016 (on-prem or IaaS).