Possibility of using composite model on on-premise tabular model with powerbi gateway?

[Spiedo]

Is it possible to use composite modeling when you host your tabular model on-premise and query it using tbe powerbi gateway?

[selimovd · Accepted solution]

Hey @Spiedo ,

I guess you mean the new composite model, the "DirectQuery for Power BI datasets and Azure Analysis Services".

At the moment as it's in preview, it's only available for Power BI datasets and Azure Analysis Services and not for on Premises Analysis Services:

DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | ...

But they plan that in the future:

SQL Server Analysis Services (SSAS): We plan to support SSAS Tabular models in the next major release of SQL Server. Support for SSAS Multidimensional models is not planned.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic