Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ProtoPrimate
Regular Visitor

Options for Loading On-Prem SSAS Multidimensional data into Fabric Data Warehouse

We have an on-prem multidemensional cube that updates daily.  We are investigating whether we should import a subset of this data into a Fabric Data Warehouse so that it can be reported on using Power BI.  The data in the warehouse would be historical by financial year/period, and it would be loaded every period.

 

What are our options for loading the data?  I found that I cannot select SSAS Multidimensional as a data source when I'm setting up my Gen2 Dataflow.  I hear that the ability to load tabular data from an on-prem SSAS instance is coming, but I don't see anything about loading multidim data.  Is this on the road map in the near future?  If not, what are my options?  I found that I can pull the data using OPENQUERY in a stored procedure, but I'm interested in whether there are better options out there.  Thanks for your help.

1 ACCEPTED SOLUTION
dbrowne
Microsoft Employee
Microsoft Employee

SSAS Multidimensional is not well suited for bulk data extraction. The MDX queries required for bulk data extract tend to be extremely expensive and slow.

Instead reuse the queries you defined in the multidimensional model's data source views to pull the data into Fabric with a Copy task or a Gen2 Dataflow.  Both the Copy task and Gen2 Dataflows support all the data sources that Multidimensional does.

View solution in original post

2 REPLIES 2
dbrowne
Microsoft Employee
Microsoft Employee

SSAS Multidimensional is not well suited for bulk data extraction. The MDX queries required for bulk data extract tend to be extremely expensive and slow.

Instead reuse the queries you defined in the multidimensional model's data source views to pull the data into Fabric with a Copy task or a Gen2 Dataflow.  Both the Copy task and Gen2 Dataflows support all the data sources that Multidimensional does.

v-nikhilan-msft
Community Support
Community Support

Hi @ProtoPrimate 
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.