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...
Need Help
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

      • jess's avatar
        jess
        Frequent Visitor
        8 years ago

        Hi All,

         

         

        I am using data source as CosmosDB to create reports in power BI for that i have a date column which i am using with date  hierarchy.so yesterday i created reports by using date  hierarchy drilldown.today when i opened the report date  hierarchy is missing and in my report drilldowns are not working can someone please help me with this problem.