Forum Discussion
Can`t link more cubes in DirectQuery
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,
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. :smileyhappy:
Regards
1 Reply
- v-ljerr-msftMicrosoft Employee
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. :smileyhappy:
Regards