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

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

        Hi jess,

         

        You can add them by hand with the Labels and the Message Tags. They are the items related to your topic. You can find them in the right side of this page.

         

        Best Regards,

        Dale