published dataset not found in fabric workspace

[Anonymous]

i connected to an azure analysis model through powerbi desktop. made a report and published it to the workspace. inside the workspace i can see the report and the semantic model i published. but when i use sempy to list all datasets, i dont see mine.
this is the code used in the fabric notebook - 

%pip install semantic-link

%load_ext sempy

import sempy.fabric as fabric

# Retrieve a list of datasets available in the workspace

df_datasets = fabric.list_datasets()

# print the entire DataFrame as a string

print(df_datasets.to_string()) #cant see my published dataset here.

[Anonymous · Accepted solution]

This bug was fixed by microsoft, now when you use 

fabricDF.to_lakehouse_table("tableName") method the table is available in both LH and pbi when you connect using LH sql endpoint.
check if the table is available in SQL analytics Endpoint before connecting through pbi.

[Anonymous]

Hi @Anonymous ,

I tested your code and it outputs fine.

Please try:

1. Ensure that you have the necessary permissions to view the dataset. 

2.By default, SemPy tries to access your semantic model from:

• The workspace of your lakehouse, if you attached a lakehouse to your notebook.
• The workspace of your notebook, if there's no lakehouse attached.

If your semantic model isn't located in either of these workspaces, you must specify the workspace of your semantic model when you call a SemPy method.

list_datasets(workspace: str | UUID | None = None, mode: str = 'xmla', additional_xmla_properties: str | List[str] | None = None) -> DataFrame

sempy.fabric package | Microsoft Learn

Read data from semantic models and write data that semantic models can consume using python

Best Regards,

Neeko Tang

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

[Anonymous]

Hi @Anonymous 

my published model, lakehouse and notebook are all in the same workspace. the other datasets which are available in the workspace are shown when using 'list_dataset()' method. but this model was published to the workspace in below manner-
1. i connected to an azure analysis model from pbi desktop.
2. made a sample report with tables.
3.published the report in said workspace, which also brings the attached model into the workspace.
4.tried to access this attached model using sempy, but it is not listed as one of the datasets.
it would be great to get your perspective on this, thank u.
BR,

Izyaan.