Forum Discussion
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
My SSIS cube is multi-dimensional but when we import it in power BI I think it converted to Tabular.
saketchinchole yes tabular is the engine used by power bi, have you tried importing it?
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?
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?