Forum Discussion

pc23's avatar
pc23
Frequent Visitor
4 months ago
Solved

Where are my datasets attached?

Hello,

 

I am trying to see if there is a way to identify which semantic models are using which datasets across multiple workpaces.

 

Currently i have only found this information by switching the view on the workspace to Lineage view, then clicking the Show Impact Across workspaces to view the information.

 

 

 

We are using Pro licenses and many of our datasets are reused across many reports. is there a more wholestic way to get this information?

 

Thanks,

Paul

Need Help
  • gauthamboppana's avatar
    gauthamboppana
    4 months ago

    pc23  - You can use the Fabric REST APIs and extract the Reports and Datasets list, and create an view.  This will help you in monitoring your datasets and reports.

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 months ago

    Hi pc23 

     

    If you go to the semantic model, and then click on View Workspace Lineage, you should then be able to see which reports are connected to your semantic model across the different workspaces.

     

    When in the lineage view make sure to click on Browse by Workspace

     

    Also another option is to use the Scanner API data which will give you all of this information.

    • pc23's avatar
      pc23
      Frequent Visitor
      4 months ago

      Thanks.

       

      Unfortunately we tend to make our reports from scratch each time so we don't reuse the semantic models generally.

       

      Defintiely something we need to look into to streamline our processes. 

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    4 months ago

    Hi. Open the workspace. Look for the three dots next to the semantic model or dataset you want to check and click at "View item lineage"

    That will open a lineage view with all the reports connected to the dataset

    I hope that helps,

    • pc23's avatar
      pc23
      Frequent Visitor
      4 months ago

      Thank you. I am only seeing the semantic models when i try this. All of our reports are created on the Desktop and not through Service. Could this be why i am only seeing the semantic models?

  • gauthamboppana's avatar
    gauthamboppana
    Icon for Solution Specialist rankSolution Specialist
    4 months ago

    pc23  - You can use the Fabric REST APIs and extract the Reports and Datasets list, and create an view.  This will help you in monitoring your datasets and reports.

    • pc23's avatar
      pc23
      Frequent Visitor
      4 months ago

      Thanks! I will get with our team to look into the suggested API.

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    4 months ago

    Hi pc23,

    We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.


    GilbertQ, gauthamboppana & ibarrau Thanks for your prompt response

     

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support