List of object that use a table

[ironpink]

Hi all,
in my company there's a DB with hundred of tabled and i added some external DB (that and i've linked). Moreover I made dozens of reports using both DB.
Now I need to change some externad DB and I need to know which are the object that reads info from a certain table that i've to change.
So, there's a chance:

1. to get a list/DB/anything that of the object in the reports whit the source of the data?
2. the list of the oblects that reads data from a certain DB?

thank you
Raffaele

[v-shex-msft]

Hi @ironpink,

I think these requirements should more suitable to processed on your database side. (you can use queries or logs to check these history operations on your database) Power bi works to get data from your database, it did not check if the target table is mapping/linking from an external server.

Regards,

Xiaoxin Sheng

[amitchandak]

@ironpink , Install DAX studio and connect with it using external tool option power bi

Run this query

SELECT 
 [OBJECT_TYPE] AS [Object Type], 
 [TABLE] AS [Object's Table], 
 [OBJECT] AS [Object], 
 [REFERENCED_OBJECT] AS [Referenced Object], 
 [REFERENCED_OBJECT_TYPE] AS [Referenced Object Type] 
FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY 
WHERE [REFERENCED_TABLE] = 'Sales'
ORDER BY [OBJECT_TYPE]

REFERENCED_TABLETable name 

Right-click on the table and use show object that referenced