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.
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?
Right, the DAX Query portion is the visual. The Direct Query portion starting on line 41 is the SQL I think.
here's what i'm doing for additional context
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |