Forum Discussion

Divya904's avatar
Divya904
Helper III
8 years ago

Connecting to multiple data sources

Hi Experts,

 

Please let me know, can we connect to multiple datasources using different Power BI connectors at the same time and create joins between tables?

 

If yes, can we do it in both query modes : Import query and Direct Query.

 

Thanks.

 

Regards,

Drony

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Divya904

     

    We cannot use multisource with direct query.

     

    Thanks

    Raj

    • Divya904's avatar
      Divya904
      Helper III
      8 years ago

      Hi Rajendran,

      Thanks for your reply.

       

      Can we use multisource with Import query?

       

      Regards,

      Divya

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Divya

         

        Yes , we can use multisource with import Query.

         

        when you work in import mode, bring only needed data to the model for better performance.

         

        Thanks

        Raj