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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

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