Solved: Import of SSAS cube

ysapiyev · ‎04-08-2018

Hi everyone,

I have SSAS cube and I've wanted to import it to Power BI report. However, I faced that doing import, I have to choose every dimension one by one. Can it be changed to load them all at once?

Regards,

Yerkhan

GilbertQ · ‎04-08-2018

Hi there

There is not currently a way to import an SSAS cube.

Your one option is correct to select each dimension.

Another option is to write a DAX (SSAS Tabular) or MDX (SSAS Multi-dimensional) and bring all the data in as one table?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

View solution in original post

GilbertQ · ‎04-08-2018

Hi there

There is not currently a way to import an SSAS cube.

Your one option is correct to select each dimension.

Another option is to write a DAX (SSAS Tabular) or MDX (SSAS Multi-dimensional) and bring all the data in as one table?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog