Forum Discussion
data democratization using power bi
- 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
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.
