FAQ Database Discussion Community


Can I load calculated measures from SSAS cube in Power Query?

excel,business-intelligence,msbi,powerquery
Power Query Version 2.17 is supporting SSAS Cubes as data source now. When I connect to a cube I just see the standard measures of the cube and not the calculated members defined in the cube. Is there a way in Power Query to get access to the calculated members?...

SSAS -How to select a particular attribute when we drag dimension into query editor

ssas,cubes,msbi
I have about 4 attributes in Race dimension as shown in blow dimension name is Race 1)Race 2)RACE DESC 3)RACE KEY 4)RACE SHORT NAME when go to cube browse and right click on Race dimension and select add query as below 1)when i drag Race dimension to browser data panel...