PowerBI

powerbi (lgrosjean variant)

Microsoft Power BI is a data analytics solution from Microsoft

The powerbi utility is used to trigger a refresh of a PowerBI dataset. Usually this is run in a pipeline following a transformation (i.e. dbt) step that altered the data that PowerBI is connected to.

EDK Based Plugin

This utility is based on the Meltano Extension Developer Kit (EDK) which is the preferred way to build and add non-Singer plugins to Meltano Hub. For more information about the EDK, please read this section of the Meltano docs. If you have any feedback or suggestions, add them to the EDK repo.

Getting Started

Prerequisites

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Installation and configuration

  1. Add the powerbi utility to your project using 
    meltano add
     : 
    2. meltano add utility powerbi
  2. Configure the powerbi settings using 
    meltano config
     : 
    3. meltano config powerbi set --interactive

Next steps

  1. Create a PowerBI Service Principal and retrieve your tenant_id, client_id and client_secret. To generate such secret and allow it to deal with your instance, follow Azure documentation

If you run into any issues, learn how to get help.

Capabilities

This plugin currently has no capabilities defined. If you know the capabilities required by this plugin, please contribute!

Settings

The powerbi settings that are known to Meltano are documented below. To quickly find the setting you're looking for, click on any setting name from the list:

You can also list these settings using 

meltano config
with the list subcommand: 

meltano config powerbi list

You can override these settings or specify additional ones in your meltano.yml by adding the settings key.

Please consider adding any settings you have defined locally to this definition on MeltanoHub by making a pull request to the YAML file that defines the settings for this plugin.

Client ID (CLIENT_ID)

  • Environment variable: POWERBI_CLIENT_ID

PowerBI Service Principal Client ID


Configure this setting directly using the following Meltano command:

meltano config powerbi set CLIENT_ID [value]

Client Secret (CLIENT_SECRET)

  • Environment variable: POWERBI_CLIENT_SECRET

PowerBI Service Principal Client Secret


Configure this setting directly using the following Meltano command:

meltano config powerbi set CLIENT_SECRET [value]

Dataset ID (DATASET_ID)

  • Environment variable: POWERBI_DATASET_ID

ID of the dataset to refresh


Configure this setting directly using the following Meltano command:

meltano config powerbi set DATASET_ID [value]

Tenant ID (TENANT_ID)

  • Environment variable: POWERBI_TENANT_ID

PowerBI Service Principal Tenant ID


Configure this setting directly using the following Meltano command:

meltano config powerbi set TENANT_ID [value]

Workspace ID (WORKSPACE_ID)

  • Environment variable: POWERBI_WORKSPACE_ID

ID of the workspace containing the dataset to refresh


Configure this setting directly using the following Meltano command:

meltano config powerbi set WORKSPACE_ID [value]

Commands

The powerbi utility supports the following commands that can be used with 
meltano invoke
:

refresh

  • Equivalent to: refresh

Refresh a PowerBI Dataset

meltano invoke powerbi:refresh [args...]

Something missing?

This page is generated from a YAML file that you can contribute changes to.

Edit it on GitHub!

Looking for help?

If you're having trouble getting the powerbi utility to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the 
#plugins-general
channel.

Install

meltano add utility powerbi

Maintenance Status

  • Maintenance Status

Repo

https://github.com/lgrosjean/powerbi-ext
  • Stars
  • Forks
  • Last Commit Date
  • Open Issues
  • Open PRs
  • Contributors
  • License

EDK Extension Repo

https://github.com/lgrosjean/powerbi-ext

Maintainer

  • Leo Grosjean

Keywords

  • analysismeltano_edkpowerbi