Search
  • Noel

Supporting both Self Service and Role Level Security in Power BI

At one time it was not possible to allow users to create their own Power BI Reports while at the same time enforcing Role Level Security. To accomplish this, we had to resort to tools like Azure Analysis Services. No more.

One thing hasn’t changed. To enforce Role Level Security in a Workspace the user can’t have creation rights in that workspace, so typically you would grant them viewer rights. What you now can do is share the dataset to the user and grant them build permission. This way when they connect to the dataset using Power BI Desktop the role level permission is enforced. They can then publish their report to a different Workspace where they have contributor rights. So, if you’re thinking this solution requires two Workspaces, one for the dataset(s) and one for self service reports you are right.

Our company has developed ChillETL, an Azure Data Factory Pipeline Manager, Scheduler and Monitor. It allows you to sit back and chill while your ADF Pipelines run like clockwork.

5 views0 comments

Recent Posts

See All

This post is for those in Information Technology working with database software. So for the rest of you have a great day and sorry to bug you with a geeky post. I just tried out Azure Data Share. It

Hello, if your customers need a data warehouse solution, we have developed tools to rapidly develop a modern data warehouse using Azure Data Factory, Azure SQL and Power BI. Our tool is called ChillET

Microsoft has just added the Fail Activity to ADF to be able force a failure within a pipeline. So no longer do you have do things like call a stored procedure to raise an error or force an invalid d