Forum Discussion
Question about lineage between tables from different workspaces
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!
2 Replies
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.
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.
