Connecting to multiple data sources

[Divya904]

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

[Anonymous]

Hi @Divya904

We cannot use multisource with direct query.

Thanks

Raj

[Divya904]

Hi Rajendran,

Thanks for your reply.

Can we use multisource with Import query?

Regards,

Divya

[Anonymous]

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]

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]

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]

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]

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