Get Workspaces from Power BI API with Python

Here's the reformatted job posting as clean, semantic HTML:

Guide on using Python to retrieve workspace data from Power BI APIs, including authentication, retrieving workspaces, artifacts, and user roles.

How to Set Up

Requires setting up a Service Principal with appropriate permissions. Detailed setup instructions including authentication are available in a separate post.

Python Implementation

• Authentication using Azure Identity ClientSecretCredential
• Retrieving access tokens for Power BI API
• Making GET requests to Power BI Admin API
• Handling JSON responses and converting to pandas DataFrames

Key code components:

• Tenant ID, Client ID, and Client Secret configuration
• API endpoint: https://api.powerbi.com/v1.0/myorg/admin/groups?$top=5000
• Error handling for authentication and API responses
• Result processing with pandas for workspace data

Note: Code is designed for Google Colab Notebook and includes recommendations for Azure Key Vault integration for production use.

Capabilities

• Get all workspaces accessible to a user or service principal
• Retrieve artifacts within workspaces (datasets, reports, dataflows)
• Identify users with roles in specific workspaces

Full code available in the linked GitHub Gist.