Share via

Different projects in Analisys services

KENY MACIEL DA SILVA 0 Reputation points
2025-10-22T15:37:39.28+00:00

I received two SSAS projects. When I open them in Visual Studio 2022, they have different characteristics:

The first one displays the Data Source and the partition section with the "SQL Statement" option.

User's image

User's image

The other project options are totally different

User's image

User's image

In this project, the option that appears is "Query Expression," using Power Query M.

And in this case, I can't change it to "SQL Statement."

Could someone tell me why this is and if it's possible to change it?

Thank you.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Akhil Gajavelly 645 Reputation points Microsoft External Staff Moderator
    2025-10-23T05:50:22.12+00:00

    Hi @Keny Maciel da Silva ,

    The difference is due to the model’s compatibility level not a missing option or configuration. If you want SQL statements, use an older compatibility (≤1200); otherwise, use Power Query M in 1400+ models.

    Thanks,
    Akhil.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.