Skip to main content

Simplify usage of Power Bi Rest API

Project description

SimplePBI

This is a simple library that makes it easy to use the Power Bi REST API. One day SimplePBI will contain all the categories in the API (Admin, datasets, reports, etc). Feel free to check the doc to get a deeper understanding of a specific request: https://docs.microsoft.com/en-us/rest/api/power-bi/
We are doing our best to make this library useful for the community. This project is not a remunerable job for us. It's a public community project. Please be patient if you submit an issue and it's not fixed right away. It's a way to express our passion of sharing knowledge.
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.

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.

Complex requests

If you want to get a deeper look on complex Admin methods. Check this doc

Current Categories

Right now the library is consuming endpoints from:

Additional content

There an aditional library Utils for transformations. It is used to help some requests returning different values. The most useful method in the Utils class might be to_pandas. You can use the method to convert simple dicts to pandas. It needs the dict and the key father of a list of dicts in the response. The usual get responses are using "value" as the key.

Small categories

Small categories like Dataflow Storage Accounts and Available Features were moved to Groups and Admin.

Missing endpoints

We are still developing the library. The following endpoints from admin are still missing

Admin

  • Set and Remove LabelsAsAdmin

Groups

  • Update group User

Datasets

  • Update datasources (regular and in groups)

Reports

  • Export To File (full request, there is a smaller simpler one)
  • Get Export To File Status (regular and in groups)
  • Get File Of Export To File (regular and in groups)
  • Update Datasources (regular and in groups)
  • Update Report Content (regular and in groups)

Imports

Create Temporary Upload Location Create Temporary Upload Location In Group Post Import (for xlsx, json and rdl) Post Import In Group (for xlsx, json and rdl)

Next Steps (planned items)

  • Completing Reports category
  • Starting a new category. It can be gateway or imports.

Change Log

0.0.1 (04/09/2021)

  • First Commit

0.0.2 (29/10/2021)

  • Completing almost all the requests in Admin Section

0.0.3 (14/11/2021)

  • Creating aditional content to admin and adding first commit for groups and datasets category

0.0.4 (15/11/2021)

  • Repo/source going public. Adding datasets and groups Power Bi Rest API category.

0.0.5 (16/11/2021)

  • Fixing error handling. Adding dataflows Power Bi Rest API category

0.0.6 (29/11/2021)

  • Fixing install module issues

0.0.7 (29/11/2021)

  • Fixing datasets for dax queries

0.0.8 (29/11/2021)

  • Fixing typo for dax queries avoiding nulls

0.0.9 (04/01/2022)

  • Adding new preview requests for subscriptions in Admin category. Those released this month by Power Bi.

0.0.10 (18/01/2022)

  • Adding all dashboards requests and 80% of reports requests.

0.0.11 (08/04/2022)

  • Adding widely shared artifacts requests for admin category.
  • Adding App category requests.
  • Adding "get" requests from import category.

0.0.12 (20/05/2022)

  • Fixing reports bugs and adding export to file as preview
  • Adding post import file to workspace (only pbix files of less than 1gb)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Built Distribution

SimplePBI-0.0.12-py3-none-any.whl (34.2 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page