Forum Discussion

rpwils's avatar
rpwils
New Member
1 year ago
Solved

Obtaining the sql query

Hi,       Does anyone know if it is possiable to obtain the actual database sql query from the semantic layer without executing the semantic layer query itself?    Thanks
capacities
  • lbendlin's avatar
    lbendlin
    1 year ago

    Not really.  Neither OLAP cubes nor SSAS Tabular run on SQL.  It's either MDX or DAX.

     

    Have a look at DAX Studio. It allows you to see which SQL-like queries are run under the hood, but those are informational only and cannot be used in any of the client tools. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

For Import Mode and generic Direct Query you can run DMV queries to return the partition definition. But if the data source query folds then you cannot retrieve that folded SQL.