Question about lineage between tables from different workspaces

Anonymous — Fri, 27 Oct 2023 15:07:24 GMT

Hello,

I have 3 workspaces composed like this :

The 3rd Workspace's tables includes a reference to a table from the 1st Workspace and another reference to a table from the 2nd Workspace.

The scan of the 3rd workspace returns :

A dataset with my 2 tables
An expression list that represent each table's expression
An "upstreamDatasets" that represent each source workspace/dataset IDs

{ "id": "[hidden]", "name": "Albums", "datasets": [ { "id": "[hidden]", "name": "group_albums", "tables": [ { "name": "SQLServer Docker - SELECT ALBUMS", "columns": [], "measures": [], "isHidden": false, "source": [ { "expression": "SELECT ALBUMS" } ] }, { "name": "Snowflake - SELECT ALBUMS", "columns": [], "measures": [], "isHidden": false, "source": [ { "expression": "SELECT ALBUMS" } ] } ], "expressions": [ { "name": "DirectQuery to AS - sql_docker", "expression": "[hidden]" }, { "name": "DirectQuery to AS - snowflake_music", "expression": "[hidden]" } ], "upstreamDatasets": [ { "targetDatasetId": "[hidden]", "groupId": "[hidden]" }, { "targetDatasetId": "[hidden]", "groupId": "[hidden]" } ] } ] }

How can i retrieve lineage between tables and expressions/upstream datasets ?

The API keeps the correct order of each items (table 1 == upstreamDataset 1 // table2 == upstreamDataset 2) ?

Thank you in advance for your time and assistance!

Re: Question about lineage between tables from different workspaces

lbendlin — Sat, 28 Oct 2023 21:20:12 GMT

Not sure what you are trying to achieve here. For all intents and purposes upstream datasets are just that - datasets (SSAS Tabular models). Doesn't really matter what feeds them.

You may have more luck using the scanner API.

Re: Question about lineage between tables from different workspaces

cnau — Fri, 25 Oct 2024 12:42:03 GMT

Worst answer ever. Of course it matters to users what base tables certain reports use as their data source.

The simplest answer here if you need to go to the table level is to employ Purview.

topic Re: Question about lineage between tables from different workspaces in Developer

Question about lineage between tables from different workspaces

Re: Question about lineage between tables from different workspaces

Re: Question about lineage between tables from different workspaces