Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am not sure if this has been answered before but as of today do we have a possibility to combine data from two different SSAS cubes. Our system collects and stores transactional data from various departments and these transactions have been summarised on a monthly level for reporting purposes. I am able to combine and view data SSRS but unable to replicate the process in BI.
Are there any plans to have a fix for this in the near future or is it something which will not be available as the functionality already exists in SSRS
Solved! Go to Solution.
This is not possible at the moment through live connection and probably not for the forseeable future.
You can use the import mode, but that would flatten the cube and make it pretty unusable. For cubes you always want to stick to a live connection.
@tannera is correct. To combine to SSAS cube data, you have to use import mode, which the data is retrieved as a table only.
Regards,
@tannera is correct. To combine to SSAS cube data, you have to use import mode, which the data is retrieved as a table only.
Regards,
This is not possible at the moment through live connection and probably not for the forseeable future.
You can use the import mode, but that would flatten the cube and make it pretty unusable. For cubes you always want to stick to a live connection.
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |