Gateway to dataset/semantic model mapping (lineage)

[data_model]

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

[pvuppala]

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]

The API call is your best option.

[pvuppala]

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

[lbendlin · Accepted solution]

We have bunch of reports connect to various gateways

Reports do not connect to gateways.

Datasets - Get Gateway Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Lea...

[data_model]

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.