Forum Discussion

Binu's avatar
Binu
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Microsoft Fabric - Direct Lake Semantic Model - Capture users accessing the model.

Hi , 

We have created multiple Direct Lake Semantic models in our Fabric workspace and shared it with many users.

The end users connect to these models using PBI Desktop, Excel and PBI reports.

Is there any way to capture the users accessing each of these semantic models. This will help us know which semantic models have very low usage and can be deprecated.

 

We have tried using "$System.discover_sessions" but this is not returning any data as Semantic Models are in "Direct Lake" mode.

Any suggestion / ideas on how to get this info ?

7 Replies

    • Binu's avatar
      Binu
      Icon for Microsoft Employee rankMicrosoft Employee

      Hi Andy ,  The requirement is to capture the "Direct Lake Semantic Model" usage and not the PBI Report usage. The Semantic model can be accessed through multiple client tools like excel , PBI Desktop , SSMS etc. Users can connect to this semantic model and create reports in their own PBI worksapce as well. So we wanted to capture the info around how many users are connecting and using these Semantic Models ( regardless of the client tools they use ) 

      • frithjof_v's avatar
        frithjof_v
        Icon for Community Champion rankCommunity Champion

        Maybe you can use Azure Log Analytics?

         

        (I don't have experience with it)

  • Binu's avatar
    Binu
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi 

    Still waiting for a resolution....

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Icon for Microsoft Employee rankMicrosoft Employee

      Hi Binu 

       

      I have reached to the internal team for the help.

      Got an update from the internal team.

      "Connect the fabric workspace to Azure Log Analytics and then you can see all the usage of all semantic models in the workspace."

      Thanks frithjof_v  for sharing the information.

       

      Thank you.