Simplify usage of Power Bi Admin API
Project description
SimplePBI
This is a simple library that makes it easy to use the Power Bi Admin API. One day SimplePBI will contain all the categories in the Power Bi Rest API (Admin, datasets, reports, etc). Each category is an Object. This means we need to initialize an object to start using its methods. In order to create them we need the Bearer token that can be obtain from a Token Object. Let's see how we can create an Admin Object to try the requests in that category.
# Import library
from simplepbi import token
from simplepbi import admin
We always need to import token object to create the object to run requests. Then we can pick the object of the Power Bi Rest API category we need. For instance "admin". The token can be created in two ways, the regular authentication and the service principal one. It depends which one you pick to complete the request. These are the necessary arguments to get a token:
- tenant_id (you can get it from subscription resource in azure portal or ask for it to the IT department)
- app_client_id (your app_id/client_id from the App registered in Azure with permissions to Power Bi Service)
- username (professional email account in Azure AD)
- password (professional password)
- app_secret_key (secret key generated for the client id)
- use_service_principal (True to athenticate with Service Principal and False to continue with user credentials)
NOTE: if you want to use service principal, be sure to have your tenant ready for that.
Register app example: https://blog.ladataweb.com.ar/post/188045227735/get-access-token
Service Principal permissions for admin api: https://docs.microsoft.com/en-us/power-bi/admin/read-only-apis-service-principal-authentication
# Creating objects
#Regular Login
tok = token.Token(tenant_id, app_client_id, username, password, None, use_service_principal=False)
#Service Principal
tok = token.Token(tenant_id, app_client_id, None, None, app_secret_key, use_service_principal=True)
ad = admin.Admin(tok.token)
As you can see the Token object contains a token attribute with the Bearer used by Azure to run rest methods. That attribute will be user to create the category objects like admin. Once we create our Object like admin, we can start using the requests adding the correct parameters if they are needed.
# Getting objects
All_Datasets = ad.get_datasets()
Datasets_In_Groups = ad.get_datasets_in_group(workspace_id)
The library get requests will return a response object .json() that python reads it as a Dict.
Current Categories
Right now the library is only consuming endpoints from Admin category.
Missing endpoints
We are still developing the library. The following endpoints from admin are still missing
- Set and Remove LabelsAsAdmin
Preview methods
There are some methods in the classes that still need more testing. Those will have a "preview" at the end of the name. Please let us know if something goes wrong with those.
Change Log
0.0.1 (04/12/2020)
- First Commit
0.0.2 (29/10/2021)
- Second build: completing almost all the requests in Admin Section
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
Hashes for SimplePBI-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 66e99a374e3fffbfd40f68a0ac172e99fc6cb276cd2b6d43479c48a85cfd9792 |
|
MD5 | a258a33d9034a424efd576ff12877a42 |
|
BLAKE2b-256 | 2a18d9176d5d4e557b48b3534af92ba2afda7c47343677528272c1e786d90278 |