Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
arjunjalan
Frequent Visitor

Querying a dataset in another workspace using semantic link.

Hi,

 

Here is the situation. I need to flatten a complex Power BI dataset for more downstream data processing. However, I only have read & build access on the dataset and DO NOT have any access on the workspace where that dataset is hosted. 

 

I am struggling to use the "fabric.evaluate_dax" measure. It keeps giving me the error of "Workspace not found". 

 

My question is - how do I query a dataset using semantic link in another workspace, on which I have build permissions ? 

 

Best,

Arjun

4 REPLIES 4
arjunjalan
Frequent Visitor

Thanks Xianda. However the documentation doesnt mention anything about how to use semantic link across workspaces. 

 

Can you please help in identifying the correct sempy code to access a semantic model from another premium capacity workspace on which I have build permissions please ? 

 

 

Hi @arjunjalan ,

To access the semantic model from another Advanced Capacity workspace using SemPy, you can perform the following steps:

  1.Installing SemPy

 

%pip install semantic-link

 

  2.List semantic model

 

import sempy.fabric as fabric

df_datasets = fabric.list_datasets()
df_datasets

 

Below is the official link will help you:

Read data from semantic models and write data that semantic models can consume using python - Micros...
Semantic Link Overview for Python | Microsoft Learn

SemPy is only supported in Microsoft Fabric, so make sure you work in that environment!

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

v-xiandat-msft
Community Support
Community Support

Hi @arjunjalan ,

The workspace in which the dataset resides has been appropriately shared with you. Even if you have read and generate permissions on the dataset, accessing it across workspaces may require workspace administrators to adjust other permissions or sharing settings.

If the semantic model is located in a user's personal My Workspace or in a Premium-enabled workspace, users without a Pro or Premium Per User (PPU) licence can only use the semantic model across workspaces for report creation.

Below is the official link will help you:

Introduction to semantic models across workspaces - Power BI | Microsoft Learn

Semantic model permissions - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi any update here please ?!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.