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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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.

Anonymous
Not applicable

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
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.