I would like to create a report with data from two different SSAS tabular cubes. The cubes have some shared dimensions. So for example if I have a slicer for the Organization dimension, and make a new selection in the slicer - I would like the visuals from both cubes in the report to be updated correspondingly.
However I can not find a way to add two different SSAS tabular cubes as datasource for one report. Does anyone know if there is a way to do this ?
Thanks for the quick reply. Unfortunately it needs to be a live connection (updates every day, security issues etc). In SSRS this is not an issue, and I am a bit surprised by this not being possible in Power BI. For us it is a significant limitation.
Thanks - it is a good suggestion to consider the tabular cubes into one. We are currently moving our cubes from multidimensional to tabular, as we clearly see that MS are putting priority on tabular. In that process we can look into having one cube (although a bit worried of it getting a bit complex).