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

Data limitations with SSAS Cubes

I have a data in ssas cube with 40Gb.I want load the data in power bi by using import. while we publish the reports into power bi services it showes the data limit is 1GB. but my data size is 40GB. how to do it and we need to do the schedule the reports automatically is there any solution ??

5 REPLIES 5
vanessafvg Super Contributor
Super Contributor

Re: Data limitations with SSAS Cubes

@saketchinchole what cube are you using mdx or tabular?  it might be less if you import it in as power bi will compress it


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
saketchinchole Frequent Visitor
Frequent Visitor

Re: Data limitations with SSAS Cubes

My SSIS cube is multi-dimensional but when we import it in power BI I think it converted to Tabular.

vanessafvg Super Contributor
Super Contributor

Re: Data limitations with SSAS Cubes

@saketchinchole yes tabular is the engine used by power bi, have you tried importing it?  


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
saketchinchole Frequent Visitor
Frequent Visitor

Re: Data limitations with SSAS Cubes

Yes, I am importing the data from SSAS...But is it my cube data size is larger (around 20GB to 30GB) Power BI Compress data and is convert it into less than 1GB so that I can published and scheduled in Power BI Service? 

vanessafvg Super Contributor
Super Contributor

Re: Data limitations with SSAS Cubes

@saketchinchole  your question isn't  clear, however what i can say is that because a cube has a lot of duplication in it and if you have modelled it correctly ie using surrogate keys in integers potentially it could compress it right down, it depends on how much text you have and thinks like the same case matters,  have you tried to import it?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,257 guests
Please welcome our newest community members: