Skip to main content
Microsoft Idea

Power BI

Completed

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

Vote (2403) Share
Sander A.'s profile image

Sander A. on 2018-07-25 14:39:12

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.

Administrator on 3/18/2022 4:15:01 AM

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

Comments (254) Merged Idea (7)
Vote 39
Stef's profile image

Stef on 2018-10-01 14:34:15

Power BI

composite models when connected to Power BI dataset

Similar to another request that is posted, but this is specifically talking about composite models using a Power BI dataset As a large enterprise we are trying to make live easier for our end users by building a set of enterprise models with pre-approved content. However we also have a number ...

Merged
Vote 2
Michael Springer's profile image

Michael Springer on 2018-03-02 04:05:45

Power BI

Relationships between Excel File or SharePoint Lists and live (tabular) SSAS data

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.

Merged
Vote 178
Power BI User's profile image

Power BI User on 2015-07-09 12:35:38

Power BI

Direct Query Semantic model

Azure SQL and Azure DW Direct Query datasources are great, and this is most probably the future. There is however a requirement for a real-time semantic model in the middle. For example, this will be great for: captions/translations, attribute order by, hierarchies, images, relationships define...

Merged
Vote 11
's profile image

on 2019-03-20 21:15:32

Power BI

Connect 2 or more live connections in Power bi desktop

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.

Merged
Vote 22
Alex Dupler's profile image

Alex Dupler on 2018-07-26 07:47:09

Power BI

Composite Models for Power BI Data Sets

I often get requests that are derivates of already released reports, but require small tweaks, such as a new dimension to be added to answer. Being able to add composite table to a live data set connection would enable me to more effectively re-use my work, as I wouldn't have to start my project ...

Merged
Vote 15
Soeren Schubert's profile image

Soeren Schubert on 2018-12-07 16:31:38

Power BI

composite models for live connections to SSAS

It would be of immense value if the feature "composite models" would also work with live connections to tabular models on SSAS. For now it is just not usable in a lot of scenarios.

Merged
Vote 7
Gareth's profile image

Gareth on 2018-04-05 19:54:44

Power BI

DAX Variable Support for Live Connection

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.

Merged