Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
decarsul
Helper V
Helper V

Query sources for.... source tables

Hi all!

 

Recently i got notified that in one of our database's a few changes are going to be made. It is now my task to investigate the possible impact on published dashboards. Changes include column name changes and datatype changes.

We address this database by querying directly with SQL to it, to import this data to a dataflow or dataset. And in most cases, the tables that are being altered are also part of unions and joins (see screenshot below for a sample of the lineage).

 

Now i'm looking for a way to be able to quickly check if these tables and columns are part of source query's. But i only seem to be able to see the 'source' via lineage, but not the actual query on that source without opening each dataset or dataflow individually. (and with atleast 150 published reports over 2 or 3 workspaces, this is tedious)

 

Is there any way to get a quick overview, or export even, where i can view the actual query's?

 

decarsul_0-1727419068884.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

there are ways, but none of them are "quick".

 

Enumerate your semantic models, then run DMV queries against the partitions and expressions for each.

For dataflows you are out of luck - there you need to export the .json manually for each of them.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

there are ways, but none of them are "quick".

 

Enumerate your semantic models, then run DMV queries against the partitions and expressions for each.

For dataflows you are out of luck - there you need to export the .json manually for each of them.

That is a shame... oh well!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors