Skip to main content

    Power BI

    Completed

    Allow more than one data source for Direct Queries.

    Vote (641) Share
    Botz's profile image

    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)
    Botz's profile image Profile Picture

    b588f0cc cbf5-4f2c-a8c7-130eec3dc16d 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.

    Botz's profile image Profile Picture

    17ab470b b02e-4ffe-8288-d9a8a5918325 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)...

    Botz's profile image Profile Picture

    5bfbce48 39d3-4a2d-b830-a0a64167f6fd 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.

    Botz's profile image Profile Picture

    2c306e97 dca2-404e-b0bd-ba09be5996fb 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?

    Botz's profile image Profile Picture

    37ee3968 b8c2-4b18-b1de-b5f5c20f6e2b 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?

    Botz's profile image Profile Picture

    d89b1cc5 6b2f-4a09-9a75-1276db9904c9 on 05 Jul 2020 23:25:27

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

    When will you include SSAS connections

    Botz's profile image Profile Picture

    b82f17c8 853b-4e57-b221-8c5cb9f33b16 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)

    Botz's profile image Profile Picture

    34bd3eac 2f96-ea11-a811-000d3a579c39 on 05 Jul 2020 23:24:57

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

    Yes we need

    Botz's profile image Profile Picture

    be1c9a59 210b-4751-beb6-669ba0d6baab 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.

    Botz's profile image Profile Picture

    cd4db27b 6418-407e-8957-521f26eb25c1 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