Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

[sander_allert1]

We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources. It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery. This would stronlgy improve the enterprise features of Power BI.

[nishalit]

I am trying to connect 2 Live connections ( Analysis services Cube) but it seems i can only connect one at a time. Would it be possible to have 2 or more live connections pointing to different Cubes in different servers.

[nishalit]

I am trying to connect 2 Live connections ( Analysis services Cube) but it seems i can only connect one at a time. Would it be possible to have 2 or more live connections pointing to different Cubes in different servers.

[nishalit]

When will we be able to blend data and create relationships between an Excel file or SharePoint lists and SSAS tabular data? This can only be done by importing data in PBI Desktop but this isn't feasible across millions of rows of data that refreshes weekly.

[nishalit]

It would be useful to allow DAX variables to be defined at the report level when using a live connection. This is currently unavailable and would make common DAX patterns such as a rolling average simpler to implement, and also make code easier to follow.

[nishalit]

The preview is underway: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | .... Please try it and provide feedback.