Skip to main content
Microsoft Idea

    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

    Power BI User on 05 Jul 2020 23:03:16

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

    This feature should have been added by now.

    Botz's profile image Profile Picture

    Jonathan on 05 Jul 2020 23:02:23

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

    Hi, PLEASE ADD THIS FEATURE!
    It is a GRADE A critical function.

    Without this there is no incentive for companies to build ready made integrations into power BI.

    Botz's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:02:17

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

    a must for Power Bi

    Botz's profile image Profile Picture

    Selva on 05 Jul 2020 23:01:12

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

    '+1 for the feature, I think MS should take this feature soon, we are populating one single with multiple data source, Power BI lack of the feature.

    Botz's profile image Profile Picture

    Andreas Kurzmann on 05 Jul 2020 22:55:39

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

    I need to combine Streaming Data (IOT) with Azure SQL Database directly in Power BI. So my Users can read all information from streaming data in good understanding way.
    Streaming data Sensor 1 from IOT, in the database Sensor 1 is Tmperature Machine 1. No user knows what sensor 1 means.

    Botz's profile image Profile Picture

    Ananda Kumar on 05 Jul 2020 22:54:40

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

    Absolutely need this. I have many customers who face this issue.

    Botz's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:51:28

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

    This would be helpful - I want to use OMS O365 logs and combine these against user IDs to match departments etc. OMS only integrates with Power BI web

    Botz's profile image Profile Picture

    Lia Solis on 05 Jul 2020 22:51:01

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

    '+ 1, this feature is absolutely necessary!

    Botz's profile image Profile Picture

    Jeremy Sedlak on 05 Jul 2020 22:49:13

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

    This request is functionally identical to the one linked below. I guess we all need to vote for both? Or do moderators review and combine like requests?

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12245109-allow-more-than-one-data-source-for-direct-queries

    Botz's profile image Profile Picture

    Jeremy Sedlak on 05 Jul 2020 22:49:12

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

    This request is functionally identical to the one linked below. I guess we all need to vote for both? Or do moderators review and combine like requests?

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12272427-allow-joining-multiple-database-with-direct-query