FAQ Database Discussion Community

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

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

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...