Power BI

Completed

Allow more than one data source for Direct Queries.

Vote (641)

Botz on 08 Feb 2016 01:24:30

In order to make Direct query more useful it needs to support data from more than one source.

Administrator on 17 Nov 2018 02:49:10

Composite models, which lets you combine multiple direct query sources in one model along with import sources, is now generally available with our November release: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#compositeModels

Comments (51)

Comments (51)

Nikhil Joy on 06 Jul 2020 00:01:06

RE: Allow more than one data source for Direct Queries.

Composite models are still not supported for data sources like SAP BW, HANA etc. Please make it possible.

Marian Scipa on 05 Jul 2020 23:53:17

RE: Allow more than one data source for Direct Queries.

Hi Power BI Team,
This still does not work with Analysis services DB sources (cubes)...

Power BI User on 05 Jul 2020 23:36:14

RE: Allow more than one data source for Direct Queries.

Hi,

Does this mean I can use what if parameters for my Direct Query dashboards in PowerBI. com? I have been waiting for this feature. If this is not yet possible. I would like to submit this as an idea.

Thanks.

Power BI User on 05 Jul 2020 23:30:33

RE: Allow more than one data source for Direct Queries.

When will this feature be deployed so that we are able to publish our models?

Anilkumar C on 05 Jul 2020 23:26:19

RE: Allow more than one data source for Direct Queries.

I see multi data source for Direct Query is available for MS SQL but not working for SAP HANA. Can I know when this feature is available for HANA source system?

Ray on 05 Jul 2020 23:25:27

RE: Allow more than one data source for Direct Queries.

When will you include SSAS connections

HK on 05 Jul 2020 23:25:18

RE: Allow more than one data source for Direct Queries.

That could be better to provide multiple data source access for live connection (direct query)

John Koziaris on 05 Jul 2020 23:24:57

RE: Allow more than one data source for Direct Queries.

Yes we need

Peter Godzina on 05 Jul 2020 23:24:24

RE: Allow more than one data source for Direct Queries.

This would be very useful. We have a lot of RSS feeds (40+) on the web with data that we want to pull into a single report, but have no capability of doing so.

Power BI User on 05 Jul 2020 23:24:19

RE: Allow more than one data source for Direct Queries.

We are planning to adopt Power BI and this feature is an absolute must. But unfortunately this is not available.

The equivalent feature seems to be available in Tableau 10.

https://onlinehelp.tableau.com/current/pro/desktop/en-us/joining_tables.html