Skip to main content

    Power BI

    New

    Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    Vote (52) Share
    's profile image

    on 26 Jan 2017 22:07:55

    I think you should be allowed to connect to multiple sources while connected to an SQL Server Database via DirectQuery.

    Comments (8)
    's profile image Profile Picture

    a950051b 20c6-ea11-a812-000d3a8ddfb2 on 31 Jul 2020 17:43:07

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    This has been open since 2017 ... don't know why Power BI Report Server does not get as much attention (unlike competitors on-premise solution)

    's profile image Profile Picture

    b588f0cc cbf5-4f2c-a8c7-130eec3dc16d on 06 Jul 2020 00:01:06

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    Same requirement for SAP BW DirectQuery. It is a surprise that this requirement is still open. Composite models are not supported for databases like SAP BW, HANA etc

    's profile image Profile Picture

    b48398d8 4470-4a4f-aea0-5626be089c5e on 05 Jul 2020 23:32:24

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    Please incorporate this feature! this will help with tracking multiple related data sources!

    's profile image Profile Picture

    e7c4f468 3a10-4c08-8f2e-168c9138263d on 05 Jul 2020 23:20:39

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    Please incorporate this feature. It would help me with tracking multiple data related sources.

    's profile image Profile Picture

    b5dc623a e407-443a-81d5-b480407a4387 on 05 Jul 2020 23:20:39

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    This would be helpful for tracking multiple related date sources

    's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:20:38

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    Please incorporate this feature! this will help with tracking multiple related data sources!

    's profile image Profile Picture

    22f4900d 0c5a-4baf-bb36-91fb8eb360b9 on 05 Jul 2020 23:20:38

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    I also find myself needing to be able to connect to multiple data warehouses. PowerBI would eliminate a significant amount of work around having to gather this data into a single warehouse if multiple sources were possible.

    's profile image Profile Picture

    52d888bb 0edb-4882-a3eb-68c99fa651b5 on 05 Jul 2020 23:16:52

    RE: Connect to multiple sources while connected to an SQL Server Database via DirectQuery

    This is a MAJOR shortcoming of PowerBI. It can't be that hard to implement.