Forum Discussion

russelp's avatar
russelp
Helper I
2 years ago
Solved

Datasetnotfoundexception even though the dataset exists when using sempy fabric functions

Hi,   I am currently getting DatasetNotFoundException: Dataset '<datasetId>' not found in workspace '<workspaceId>'  (Just replaced the actual values with <>)   The issue is the dataset actually...
data engineering
  • russelp's avatar
    russelp
    2 years ago

    Not sure how to delete this but this has been solved. I just created a new table after enabling the sync the default power BI semantic model and it is now showing the updated dataset tables. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi russelp 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

russelp's avatar
russelp
Helper I
2 years ago

Hi Anonymous ! Thank you! I don't want to open up another thread just for this follow up question related to this so, does the sempy fabric function list_datasets() only show my owned datasets? I created my lakehouses and able to see the datasets but when my coworker created one, I am not able to see that new dataset. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi russelp 
    Did your co-worker created the dataset in the same workspace or different workspace?
    The list_datasets() function from the sempy.fabric package lists the available semantic models in your workspace. It does not specifically filter datasets based on ownership. If you are unable to see a dataset created by your coworker, it could be due to a variety of reasons such as access permissions, dataset visibility settings.
    Read data from semantic models and write data that semantic models can consume using python - Microsoft Fabric | Microsoft Learn

    Hope this helps. Please let me know if you have any further questions.

    • russelp's avatar
      russelp
      Helper I
      2 years ago

      Hi Anonymous thank you for answering! Yes, we created our datasets in the same workspace. When she ran the same function, she was able to see only her datasets. We are only seeing our own datasets (when querying from list_datasets()). Which access permissions should we check? Currently, we are both admins in the same workspace so what other access permissions should we take a look at? 

       

      Edit: For extra context

      These are the permissions I have on the semantic model: 

       

      These are the permissions I have in the SQL endpoint:

      These are the permissions I have in the Lakehouse: 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi russelp 
        You can try giving the semantic model permissions to the co-worker :

         





        Give the permissions for your co-worker and retry. 
        Thanks