Import of SSAS cube

[ysapiyev]

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 · Accepted solution]

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?