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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to get SQL out of composite model over two PBI DQ datasets

We have a composite model build using two PBI datasets that have DQ to Synapse. I'm trying to capture the SQL query generated by a visual as I would on a single DQ source model. However all I was able to get was the DAX. 

 

I've tried to do Server Timings trace in DAX Studio as well as SQL profiler but no luck. Is this just not an option?

3 REPLIES 3
jdbuchanan71
Super User
Super User

Right, the DAX Query portion is the visual.  The Direct Query portion starting on line 41 is the SQL I think.

Anonymous
Not applicable

here's what i'm doing for additional context 

ichifay_0-1623427651546.png

ichifay_1-1623427744676.png

ichifay_2-1623427889139.png

 

 

jdbuchanan71
Super User
Super User

I think if you copy the query from the performance analyzer then paste it into DAX Studio it will ask if you want just the DAX or the full query which will include the SQL.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.