Power BI Studio installs statistics

Power BI Studio

A VSCode extension for managing your Power BI tenant using the Power BI REST API and modify Power BI datasets using TMDL (Tabular Model Definition Language) from within VSCode.

Installation

The extensions can be installed directly from within VSCode by searching for this extension (GerhardBrueckl.powerbi-vscode) or downloaded from the official Visual Studio Code extension gallery at PowerBI VSCode and installed manually as VSIX.

Features

• GUI to browse your workspace and run operations like rebind, clone, ...
• Modify Power BI datasets using TMDL - see TMDL
• Supports VSCode and vscode.dev
• Connect to remote tenants where you are invited as a guest user - see Configuration
• Run DAX queries in a notebook against your Power BI Datasets using %dax magic
• Run arbitrary REST API calls in a notebook using %api magic - see Notebooks
• Drag & Drop to run certain commands (e.g. drop a report on a dataset to rebind it)
• GUI to manage Capacities, Gatways and Pipelines

Configuration

The extension supports the following VSCode settings:

Setting	Description	Example value
powerbi.tenantId	(Optional) The tenant ID of the remote tenant that you want to connect to.	A GUID, abcd1234-1234-5678-9abcd-9d1963e4b9f5
powerbi.clientId	(Optional) A custom ClientID/Application of an AAD application to use when connecting to Power BI.	A GUID, 99887766-1234-5678-9abcd-e4b9f59d1963
powerbi.cloud	(Optional) Only use when you want to connect to a sovereign or governmental cloud!	GlobalCloud
powerbi.TMDL.clientId	(Optional) To use TMDL features, a custom ClientID/Application can be used. You can use 058487e5-bde7-4aba-a5dc-2f9ac58cb668 and make sure its permitted in your tenant or you can create your own AAD application in your AAD tenant (see README) for details. If this is configured, VSCode will manage the authentication and also remember it!	A GUID, 058487e5-bde7-4aba-a5dc-2f9ac58cb668
powerbi.TMDL.enabled	Set to true (default) to allow editing Power BI datasets using TMDL.	true(default)/false
powerbi.workspaceFilter	(Optional) A regex to filter workspaces by name. Only workspaces matching this regex will be shown in the Power BI Workspaces view.	Project A|Sales to see only workspaces that have "Project A" or (|) "Sales" in the name
powerbi.datasetRefreshCheckInterval	(Optional) The number of seconds to wait between checking for completed dataset refreshes in the background. Set to 0 to disable automatic refresh checks.	60

Notebooks

You can open a new Power BI notebook via the UI from the header of each treeview or by running the command Open new PowerBI Notebook (command PowerBI.openNewNotebook). Power BI notebooks have the file extension .pbinb and will automatically open in the notebook editor.

The following features are supported by notebooks and can be used using magic tags in the first line of the cell:

• running arbitrary REST API calls (magic %api)
• executing DAX queries against a dataset (magic %dax)
• executing TMSL statements against a dataset (requires TMDL) (magic %tmsl)
• setting variables to be used in subsequent cells (magic %cmd)

Next to the magic itself you can also specify a custom API endpoint for every cell right after the magic tag:

%dax /groups/ccce57d1-10af-1234-1234-665f8bbd8458/datasets/51ba6d4b-1234-1234-8635-a7d743a5ea89
EVALUATE INFO.TABLES()

This overwrites the API_PATH set for the notebook to run DAX queries. You can now run multiple DAX statements against different datasets from within the same notebook without changing the API_PATH every time. For example if you want to run the same query against TEST and PROD to compare results etc.…