Forum Discussion

data_model's avatar
data_model
Frequent Visitor
2 years ago
Solved

Gateway to dataset/semantic model mapping (lineage)

Hello,

We have bunch of reports connect to various gateways to connect to different data sources. We map underlying semantic models/datasets (in multiple workspaces) to various gateways (for import/direct query). I am wondering if there is an easy way to list which reports/semantic models use/connect to what gateways, kind of lineage. Appreciate any inputs.

 

Best Regards

Need Help
Tips and Tricks

5 Replies

    • data_model's avatar
      data_model
      Frequent Visitor
      2 years ago

      Thanks @Ibendlin. 

      I don't mean reports directly connect to gateway, just trying to give the context that there are lot of reports. I think may have to loop through all workspaces & datasets etc., will try this.

      Thanks again.

  • pvuppala's avatar
    pvuppala
    Helper V
    1 year ago

    Hello,

    My team is looking for the same, trying to identify all "Offline" gateway connections and if they're being used anywhere within workspaces/semantic models.  Has anyone figured out a way how to see a lineage or mapping for Gateway data source -->Semantic Models?

     

    Thanks in advance!

      • pvuppala's avatar
        pvuppala
        Helper V
        1 year ago

        The problem I'm running into is the 200 request limit.  Here's what I'm going with this approach.

        1. Get all Active workspaces

        2. Loop through all Workspaces for datasets

        3. Another Loop through all datasets where isOnPremGatewayRequired is True

        4. Capture workspace, dataset, gateway datasource info etc., write back to csv

        5. I have to include a "Wait" command in the PowerShell script an hour since the first call was made.

         

        I will keep you guys posted!  I'm just surprised MSFT did not make any of this easy to trace from gateway connections to semantic models for Governance and Administration perspective.

         

        Thanks!

        -Pawan