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.
Go to Solution.
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.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.