cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Afer Frequent Visitor
Frequent Visitor

Report with data from two different SSAS tabular cubes

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: Report with data from two different SSAS tabular cubes

Hi @Afer

 

Sorry about that.  Given the MS build SSRS they will understand the usefulness of your request.  In the meantime Import does have a bunch of features that handle refreshing daily and security etc.

 

Otherwise, can you combine the Tabular cubes into one?  

 

Remember Power BI is just a Tabular cube, so if you use the same source data your SSAS cubes use, you can effectively clone your cuebs.  Just some thoughts really.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

5 REPLIES 5
Phil_Seamark Super Contributor
Super Contributor

Re: Report with data from two different SSAS tabular cubes

HI @Afer

 

If you are using Live Query then you will be limited to one data source.  Is importing the data from both datasets an option?

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Afer Frequent Visitor
Frequent Visitor

Re: Report with data from two different SSAS tabular cubes

Hi Phil,

 

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.

Phil_Seamark Super Contributor
Super Contributor

Re: Report with data from two different SSAS tabular cubes

Hi @Afer

 

Sorry about that.  Given the MS build SSRS they will understand the usefulness of your request.  In the meantime Import does have a bunch of features that handle refreshing daily and security etc.

 

Otherwise, can you combine the Tabular cubes into one?  

 

Remember Power BI is just a Tabular cube, so if you use the same source data your SSAS cubes use, you can effectively clone your cuebs.  Just some thoughts really.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Afer Frequent Visitor
Frequent Visitor

Re: Report with data from two different SSAS tabular cubes

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). 

Phil_Seamark Super Contributor
Super Contributor

Re: Report with data from two different SSAS tabular cubes

Hi @Afer,

 

Thats a shame about the move from MDX to Tabular.  I still feel there is a place for MDX and in larger, more complex models they outshine their Tabular counterparts.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 19 members 743 guests
Please welcome our newest community members: