Power BI Linked Service - failed to load workspace

Published Jun 26 2020 04:29 PM 2,912 Views
Microsoft

Azure Synapse Analytics Workspace, one stop shop, also enables you to view, edit, create your Power BI Reports from Data tab. But when you try to add new Power BI linked service you get 'failed to load workspace' error.  In this post you will learn how to configure linked service for Power BI for first time.

 

Linked Services are available from Manage tab of Synapse workspace. You can add or remove linked service from that pane

tejalsd_0-1593211279111.png

 

When you try to add Power BI linked service, you get 'Failed to load workspace error'

tejalsd_1-1593211442642.png

 

Following are steps to get the linked service created.

  1. This happens when you just have default workspace i.e. 'My workspace' in your Power BI.
  2. Create a new workspace from PowerBI.com portal with name relevant to you business reports and usages.  e.g. I have created a new workspace - PowerBIPoc. Note : You will require min Power BI Pro license to have new workspace.
  3. Now try again to add linked service from Synapse workspace, you will find newly created Power BI workspace has appeared in the dropdown list.
 
 

tejalsd_0-1593212825613.png

 

tejalsd_1-1593212889769.png

4. You can now work on your reports.

 

 

tejalsd_2-1593213422577.png

 

 
 
 

 

 
 
 

 

2 Comments
Version history
Last update:
‎Jun 26 2020 04:33 PM
Updated by: