Quickstart: Linking a Power BI workspace to a Synapse workspace

In this quickstart, you learn how to connect a Power BI workspace to an Azure Synapse Analytics workspace to create new Power BI reports and datasets from Synapse Studio.

If you don't have an Azure subscription, create a free account before you begin.

Prerequisites

  1. Starting from Synapse Studio, select Manage.

  2. Under External Connections, select Linked services.

  3. Select + New.

    + New linked services is highlighted.

  4. Select Power BI and select Continue.

    Displaying Power BI linked service.

  5. Enter a name for the linked service and select a workspace from the dropdown list.

    Tip

    If the workspace name doesn't load, select Edit and then enter your workspace ID. You can find the ID in the URL for the PowerBI workspace: https://msit.powerbi.com/groups/<workspace id>/

    Displaying Power BI linked service setup.

  6. Select Create.

View Power BI workspace in Synapse Studio

Once your workspaces are linked, you can browse your Power BI datasets, edit/create new Power BI Reports from Synapse Studio.

  1. Select Develop.

  2. Expand Power BI and the workspace you wish to use.

    Expand Power BI and the workspace.

New reports can be created selecting + at the top of the Develop tab. Existing reports can be edited by selecting on the report name. Any saved changes are written back to the Power BI workspace.

View and edit Power BI report.

Learn more about creating Power BI report on files stored on Azure Storage.