How to connect the whole Dimension/Folder OLAP Cube in SSAS instead of clicking each cube

[MYDATASTORY]

Hi,

Please advice,

I was just wondering if there is an easy way of connecting to (OLAP Cube in SSAS) the root folder instead of clicking each an every cube as per the below example. I have an OLAP cube but to connect this to Power BI I have to pick individual cube (1,2,3,4,5)  as per the below image, I would like to connect with the Main folder as per image. Data is coming from OLAP Cube in SSAS from Adobe Analytics Data. I was just thinking if there a DAX code or even using a query editor minimize this clicking of the individual cube which load which can be tiresome if you have so many cubes. Thanks in advance.

 

[mwegener · Accepted solution]

Hi @MYDATASTORY ,

can you use a LIVE connection?

[Icey · Accepted solution]

Hi @MYDATASTORY ,

Just as what @mwegener mentioned, please try to use "Live Connection" / "Connect Live" mode.

Reference: 

Live Connection; When Power BI comes Hybrid;

Power BI Connections: Live Connection.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener · Accepted solution]

Hi @MYDATASTORY ,

can you use a LIVE connection?