Skip to content

Latest commit

 

History

History
65 lines (40 loc) · 2.62 KB

File metadata and controls

65 lines (40 loc) · 2.62 KB
title Quickstart: Linking a Power BI workspace to a Synapse workspace
description Link a Power BI workspace to an Azure Synapse Analytics workspace by following the steps in this guide.
author gillharmeet
ms.service azure-synapse-analytics
ms.topic quickstart
ms.subservice business-intelligence
ms.date 12/20/2024
ms.author harmeetgill
ms.custom
mode-other
sfi-image-nochange

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

Link Power BI workspace to your Synapse workspace

  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.

Related content

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