question

JoeKastner-2406 avatar image
JoeKastner-2406 asked ·

Unable to create Linked Service in Synapse Analytics to Power BI

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
power-bi-linked-service-creation.png (13.2 KiB)
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

PRADEEPCHEEKATLA-MSFT avatar image
PRADEEPCHEEKATLA-MSFT answered ·

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.



azuresynapse-powerbilinked-service.gif (812.9 KiB)
1 comment Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NithySingaravelu-4760 avatar image NithySingaravelu-4760 ·

Looks like one should not have ad-blockers as per this documentation. I was able to create the Power BI link only after "Allowing All cookies"

https://docs.microsoft.com/en-us/azure/data-factory/data-factory-ux-troubleshoot-guide#third-party-cookies-blocked

0 Votes 0 · ·
ErwindeKreuk-6515 avatar image
ErwindeKreuk-6515 answered ·

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




workaccount-to-test-tenant.jpg (33.5 KiB)
test-account-to-test-tenant.jpg (36.9 KiB)
Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.