Unable to create Linked Service in Synapse Analytics to Power BI

Joe Kastner 21 Reputation points
2020-05-22T11:22:58.983+00:00

Hi!
I'm trying to connect Power BI to Azure Synapse Analytics but I'm unable to create the linked service. When I go to create the linked service, the workspace name does not appear it's locked as loading...

8550-power-bi-linked-service-creation.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,669 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 85,351 Reputation points Microsoft Employee
    2020-05-22T12:55:49.587+00:00

    Welcome to the Microsoft Q&A platform.

    Make sure you have "Created the new workspaces in Power BI" as a prerequisites.

    I'm able to link a Power BI workspace to a Synapse Analytics workspace, without any issue.

    8583-azuresynapse-powerbilinked-service.gif

    In case, if you have already have workspaces in Power BI. You may try the following steps:

    • Clear “Cookies and Cached data” of your browser.
    • Private Mode (New InPrivate Window).
    • Try in different browser.

    Reference: Quickstart: Linking a Power BI workspace to a Synapse Analytics workspace (preview)

    Hope this helps. Do let us know if you any further queries.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Erwin de Kreuk 101 Reputation points MVP
    2020-06-09T07:44:09.627+00:00

    9551-workaccount-to-test-tenant.jpg

    9561-test-account-to-test-tenant.jpg
    Hi, I've the same problem here.

    But it looks like you cannot connect to a PowerBI Workspace in a different tenant.

    I've created a Workspace with my Workaccount in my Test Tenant(in the picture Inspark Labs). After that I want to create a Linked Service for PowerBI but there's not Workspace Available.

    I've assigned the same right to my test account to de AS Workspace and now I can connect to my Workspace

    To solve the issue. I've enabled the option to Allow external guest users to edit and manage content in the organization
    Enabled for the entire organization in the Powerbi admin Portal. Gave my workaccount access to a Workspace and now I can connect to the Workspace in Synapse Studio.

    Erwin

    1 person found this answer helpful.
    0 comments No comments

  2. Yasar Kocyigit 6 Reputation points
    2021-10-04T22:23:57.713+00:00

    When you are connecting to power bi workspace you can use workspace id
    (your both account must be same it doesn't work under different tenant)

    137497-pbi-connect.png

    here is where can you find power bi workspace id:

    137507-workspace-id.png

    0 comments No comments