topic Re: Gateway to dataset/semantic model mapping (lineage) in Developer

Gateway to dataset/semantic model mapping (lineage)

data_model — Thu, 22 Aug 2024 23:23:23 GMT

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

Re: Gateway to dataset/semantic model mapping (lineage)

lbendlin — Fri, 23 Aug 2024 01:01:15 GMT

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 Learn

Re: Gateway to dataset/semantic model mapping (lineage)

data_model — Fri, 23 Aug 2024 14:01:23 GMT

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.

Re: Gateway to dataset/semantic model mapping (lineage)

pvuppala — Tue, 18 Feb 2025 21:18:28 GMT

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!

Re: Gateway to dataset/semantic model mapping (lineage)

lbendlin — Tue, 18 Feb 2025 21:47:20 GMT

The API call is your best option.

Re: Gateway to dataset/semantic model mapping (lineage)

pvuppala — Wed, 19 Feb 2025 03:25:56 GMT

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