Showing results for 
Search instead for 
Did you mean: 
Not applicable

Composite Model in Desktop Report Server



I have a report wherein I need to use both live SQL and Excel connection. As soon as I add Excel connection I am prompted to switch the data access mode to import. I know composite model was added recently in Power BI cloud. Is there an option to achieve this in Report Server desktop version.





Jon-Heide Established Member
Established Member

Re: Composite Model in Desktop Report Server

No not yet. It's under consideration for an upcoming release. Please do upvote the idea on PowerBI user voice! 

manalla Member

Re: Composite Model in Desktop Report Server

This has come out in NOV 2018 for PBI service.

 For report server we anticipated in Jan 2019 or May 2019 releases, but no luck for us.


Any one has better update?




jzaib Frequent Visitor
Frequent Visitor

Re: Composite Model in Desktop Report Server

I installed the On-Premises (May 2019) and I can't see that in the option/settings.


Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 207 members 1,902 guests
Please welcome our newest community members: