Querying a dataset in another workspace using semantic link.

[arjunjalan]

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

[arjunjalan]

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 ? 

[Anonymous]

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.

[anshi_t_k]

Hi,
Any update on this

[Anonymous]

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.

[arjunjalan]

Hi any update here please ?!