Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow composite model in Power BI Report Server

Vote (225) Share
AngusF's profile image

AngusF on 01 Aug 2019 12:55:36

Released in PowerBI Desktop last November 2018, please make the "composite model" functionality available in Power BI Report Server. Key functionality requried is being able to use Direct Query against more than 1 data source, or mix Direct Query and Import in the 1 PowerBI report.

Currently Power BI Desktop (optimized for Power BI Server) will force you into Import mode once you start to mix data sources, which can see you importing a lot of data.

Thank you,

AngusF

Comments (18)
AngusF's profile image Profile Picture

Jesper Sudergaard Lauritzen on 08 Nov 2023 13:50:17

RE: Allow composite model in Power BI Report Server

This is needed, Can't see why you havn't implemented it already. Considering when it came in the cloud version.

AngusF's profile image Profile Picture

Arun Bhuvanendran on 16 May 2023 21:17:59

RE: Allow composite model in Power BI Report Server

Hello PBI Team,We are a Finance firm, for compliance we have all our data within our On-Premise Servers. No support for Composite Model & Many to Many relationship in PBI Report Server is soo frustrating and limiting, because we are heave PowerPivot Data Modeling customer and as an architect i am trying to implement SSAS & PBIRS end to end solution and we are stuck now with some of the complex report which has more than 1 kind of data source connection and the join support limitation.Any update on future plans to support this functionality will shed some light for us to move forward with PBIRS.ThanksArun

AngusF's profile image Profile Picture

James Anderson on 14 Feb 2023 11:08:24

RE: Allow composite model in Power BI Report Server

I can not use PowerBI Report Server for PowerBI reports at all without this feature. We have spent years and thousands of pounds trying to implement PowerBI Report Server onto our portal and have finally hit this dead end.Microsoft, you should make the On-Prem version of PowerBI identical to the Cloud version - why you have decided to develop two different versions of the same product shows poor quality of design from the outset.Bear in mind, that in Tableau, which is a far superior product, the features are identical, whether you are on cloud or on-prem, and also, the Direct Query and Import modes have identical functionality, and even, you can switch back from Import mode to direct query.

AngusF's profile image Profile Picture

David Chauncy on 29 Jun 2022 23:03:38

RE: Allow composite model in Power BI Report Server

This is needed otherwise we will move to Tableau

AngusF's profile image Profile Picture

Peter Hind on 27 May 2022 05:15:09

RE: Allow composite model in Power BI Report Server

This would be such an amazing feature, especially after hearing about composite model support with analysis services tabular models coming in the future SQL server 2022 release.

AngusF's profile image Profile Picture

Karthik Vengatesan on 12 Mar 2022 08:15:01

RE: Allow composite model in Power BI Report Server

Any idea when this feature would be coming in upcoming releases. Cheers

AngusF's profile image Profile Picture

Gavin Langford on 02 Feb 2022 09:48:52

RE: Allow composite model in Power BI Report Server

We need this to make the product viable to use. For fast development this is a must.

AngusF's profile image Profile Picture

Stephen Casterline on 21 Jan 2022 01:16:03

RE: Allow composite model in Power BI Report Server

This would be great!

AngusF's profile image Profile Picture

Power BI User on 21 Oct 2021 14:41:38

RE: Allow composite model in Power BI Report Server

Not having this on PBI Report Server is a massive negative.

AngusF's profile image Profile Picture

Phil Pearson on 12 Aug 2021 12:16:06

RE: Allow composite model in Power BI Report Server

Not having this on PBI Report Server is a massive negative. It forces you to store everything in a db of some kind. The overheads of permission and data management for sometimes trivial bits of data.

Merged Idea (2)