Forum Discussion
data democratization using power bi
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
Hi SaiTejaTalasila ,
please see below steps which I am planning for this process. we currently use service now, sharepoint and JIRA tools. please let me know if below process looks fine to you. i hope below should be doable
1. we will pull all metadata (report, dataset and workspaces) from Power BI using rest api and store in snowflake database
2. power bi report will be created using database mentioned in previous point
3. report will be converted to an app
4. app will be assigned to organization level group where all employees can see that app
5. subcribe button will be provided in front of each report in power bi app
6. once user click on subscribe then service now incident will be raised, integration between power bi and service now will be done using power automate
7. report owner will receive email of report name and type of access (read/write)
8. report owner will manually assign user to a report or workspace or share dataset with read or write access
That may work for a small company. In an enterprise environment you better use enterprise level user access management tools.
Hi lbendlin ,
Even that works.if possible you can improve the process once the request is raised in service now it should submit a request to a Sailpoint iiq group and the group owner will receive access request once the approval is done by owner the user will get access automatically to the power bi app.
Step7 and step8 you can try to automate it .
2nd option -
report owner gets the user email and access type in an excel file by the end of every day and he can use power shell and rest API commands and provide the access with in less than 5mins for multiple users.
I hope it will be helpful.
Thanks,
Sai Teja
