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
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