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/...
Need Help
Tips and Tricks
pvuppala's avatar
pvuppala
Icon for Helper V rankHelper 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!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

The API call is your best option.

  • pvuppala's avatar
    pvuppala
    Icon for Helper V rankHelper 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