Can`t link more cubes in DirectQuery

[Anonymous]

Hi,

Using directQuery, I want to extract data from different cubes. However when I connect my first cube I do not have the option to get a new one.

Is this something standard? Should I create a new cube with all the data which I need? i.e. I need Sales (FI - AR) & Materials (CO - PA)

What is your advise to show everything in my Dashboard?

Really appreciate your help and advice. 

Kind regards,

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

This is currently a known limitation that when using Direct Query Mode or connect live with Power BI Desktop, you are limited to just one data source/database you selected.

Followings are two similar ideas shared on Power BI Ideas forum. You can vote them up and add your comments there to improve Power BI on this feature.  

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12272427-allow-joining-multiple-database-with-direct-query

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12532173-ssas-get-data-multiple-data-sources

Regards