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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!