Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
thank you
Raffaele
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
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |