Forum Discussion

Divya904's avatar
Divya904
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper 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.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi jess,

         

        I would suggest you open a new thread in this forum since your topic isn't related to this one.

         

        Best Regards,

        Dale