Forum Discussion
Workspace, semantic model, report, users and dataset lifecycle management
I am a Power BI Admin within my organization (not a Global Tenant Admin). My primary responsibility is as a Capacity Admin, and I manage several workspaces, datasets, and capacities.
We have recently started working on Dataset (Semantic Model) Lifecycle Management, and as part of this initiative, I am looking for a way to gain better visibility and governance across the workspaces I administer.
Specifically, I would like to know if there is a recommended or supported approach to retrieve the following information across workspaces where I am an admin:
- All workspaces
- Workspace users along with their roles (Admin, Member, Contributor, Viewer)
- Semantic models (datasets)
- Reports and dashboards associated with those workspaces
I have attempted to use a few Power BI REST APIs via PowerShell scripting, but I would appreciate guidance on:
- Which REST APIs are best suited for this purpose
- Any prerequisites or tenant settings required
- Best practices to gain full administrative control and visibility over the workspaces I manage (without being a Global Admin)
Any suggestions, documentation references, or sample approaches would be greatly appreciated.
Thank you in advance for your support.
palamanb_Risk appriciated to help you. Here are the outlined steps to do the same.
1) Copy the attached .MEZ file on C:\Users\MagnusMinds\Documents\Power BI Desktop\Custom Connectors folder on your machine.
2) Open power bi desktop and do this setting and restart the power bi. (This is a setting to use the custom connectors)
3) Open power bi and clcik get data -> search for custom or any relevent text
4) After click it ask you to allow third party connectors.
5) It list the available API endpoint in a form of function you can use whatever you need
6) Load data and build the dahboard/report as your own. Then below are the steps for the gateway setup and refresh same report on the service on schdule basis.
Add the custom connector folder here in the connectors section.
create the gateway on the service using this connector use it in the semantic model as well.
I hope this helps! If this resolves your issue, please mark this as the Accepted Solution to help others.
Note: Try to do in the hierarchy like (workspace\group -> Dataset -> Report etc....) As the respective function need the parent as a parameter.
23 Replies
Hi palamanb_Risk,
Thanks for reching fabric community, will happy to assist.I encountered a very similar scenario in a previous project where the team was manually managing shell scripts and database tables to ingest API data before consuming it. To streamline this, I proposed and implemented a Power BI-native solution that brings inventory information directly into a centralized dashboard.
I have developed an end-to-end Proof of Concept (PoC) featuring:
Custom Power BI Connector: Utilizes a robust library of M functions to interface directly with REST APIs.
Automated Refresh: Published to the Power BI Service and configured for scheduled updates via an On-Premises Data Gateway.
I am attaching a screenshot of the sample report for your reference. While this is a foundational PoC, it demonstrates the core functionality. Please let me know if this approach aligns with your requirements, and I would be glad to guide you through the next steps.
Note: You can leverage additional functions from the API catalog or further customize the connector if you are familiar with Power Query/M logic.
I think this would help you a lot - https://github.com/microsoft/powerbi-powershell.
Also this is an intro article by Radacad into this setup if you want to start.Hi Lodha_Jaydeep ,
Thanks for the quick response. Can you please explain in detail about the solution- thankspalamanb_Risk appriciated to help you. Here are the outlined steps to do the same.
1) Copy the attached .MEZ file on C:\Users\MagnusMinds\Documents\Power BI Desktop\Custom Connectors folder on your machine.
2) Open power bi desktop and do this setting and restart the power bi. (This is a setting to use the custom connectors)
3) Open power bi and clcik get data -> search for custom or any relevent text
4) After click it ask you to allow third party connectors.
5) It list the available API endpoint in a form of function you can use whatever you need
6) Load data and build the dahboard/report as your own. Then below are the steps for the gateway setup and refresh same report on the service on schdule basis.
Add the custom connector folder here in the connectors section.
create the gateway on the service using this connector use it in the semantic model as well.
I hope this helps! If this resolves your issue, please mark this as the Accepted Solution to help others.
Note: Try to do in the hierarchy like (workspace\group -> Dataset -> Report etc....) As the respective function need the parent as a parameter.
I am not able to attach the .mez file. giving you the drive link to downlaod it.
https://drive.google.com/file/d/10gjJ6P-pC95m9Qepqm3l-pktE6HydbfN/view?usp=sharing
Hi palamanb_Risk ,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
