Forum Discussion
data democratization using power bi
I am trying to build "data democratization" process in power bi . below mentioned are the key objectives of the process. I am using premium capacity license, Can it be possible to acheive below in power bi primarily if possible?
1. Visibility of all Reports , Datasets and Workspaces to New Users:
- new user i.e . users who do not have pro or premium license should be able to see the list of all reports , datasets and workspaces along with high level description of each report ,datasets and workspaces.
- new user should be able to see all shared datasets if available in power bi
2. Automated process to get Power BI report access:
- once user see the reports list along with their descriptions , he/she should be able to raise request to get report access
- specific person example, owner of reports will receive access request via email or any other mechanism and will provide approval or deny the request
- new user should receive notification email once request is approved by the owner along with report link or deny notification
- new user should be able to select request type which can be "view" access for providing read only access of reports and "edit access" for self service capability for generating reports based on shared datasets
Note:
- above points mentioned should be handled in power bi primarily if possible or any other generic tools such as Service Now, JIRA. example , process for raising request to get report access can be handled in power bi if possible or any other tool like JIRA etc
16 Replies
- how big is your company? How many reports do you expect to exist?
- how old is your company (ie how many legacy processes)?
- is your company a "pure" Azure shop or is it a hodgepodge of thousands of heterogenous offerings?
- does your company have the strategic willingness to invest in data stewardship and data subject certifications (and maintenance)?
Hi lbendlin
please see below answers
- company size is around 18000 employees. there would be around 300 plus reports
- company is 30 years old, we have 7 diferent departments and for each department there are 5-6 sub departments
- we are currently using Azure Data Factory for building ETL pipelines and using Snowflake as data warehouse where data beling collected from ERPs , CRMs, ecommerce and marketing platforms
- Our company do not have strategic willingness to invest in data stewardship and data subject certifications (and maintenance)
Hi powerbiexpert22 ,
You can create a report with report name, owner and hyperlinks to your reports and make it public after publishing the report to premium capacity.If required you can make that report link available across your websites.So, the users will be able to use that report and uses the hyperlink and raise the request for access.As per my knowledge some people will use Microsoft forms or even servicenow integrations and Sailpoint iiq queues to manage access related things.In our organisation as part of tenant admin team we have a report to track the report details based on report name or workspace name.So, if anyone reach out to us we will be able to provide the report owner details.
I hope it will be helpful.
Thanks,
Sai Teja
Thanks,
Sai Teja
Thanks,
Sai Teja
powerbiexpert22 Well, for visibility, you could share datasets, etc. with All Company group or something similar. However, this will actually give them at least read access to it. So, if you want to expose content items that they do not already have access to then I think you are going to need to create a separate site that exposes this information. You can get this information from the Power BI REST API's. Perhaps something like using a PowerApp or Power Pages to do this would work (or just any old website) and the workflow could be handled by Power Automate.
Hi Greg_Deckler ,
thanks, how I would give shared dataset access to all company group? can it be done for reports also?
what do you mean by exposing content items?
I am not sure if I can utilize apps feature for this however if we use apps then we need to first create apps for all existing reports which would be additional task for me
powerbiexpert22 Well, I Azure tenant came with an All Company group with an email address of allcompany@[tenant].onmicrosoft.com. So, in theory you could share a content item with that group and then everyone would have the rights you specify to that item. Or you could use a similar, not built-in group, an "everyone" group.
