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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft 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

      • jess's avatar
        jess
        Frequent Visitor
        8 years ago

        Hi 

         

        I tried opening new thread it asking me to add label with commas,which am unable to understand.ifu can please giude me opening the new thread that would be helpful

         

        Tnaks,

        Jess.