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