Forum Discussion
Can you query a semantic model in the workspace using SQL?
Hello everyone, I know that you can connect to the workspace using SSMS through XMLA endpoint, however you have to use DAX or MDX when query the dataset in SSMS. Is it possible to switch to SQL? ...
BenBlackswan While you cannot directly query Power BI semantic models using SQL, understanding and utilizing DAX and MDX is essential for working within Power BI. For those who prefer SQL, leveraging DirectQuery with a robust SQL backend can offer a practical compromise, allowing you to use SQL for data manipulation and DAX for advanced analytics within Power BI.