CODEWITHSUNDEEP
excelbusiness-intelligencemsbipowerquery
Andi
Andi

Reputation: 507

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?

Upvotes: 0

Views: 85

Answers (1)

Andi
Andi

Reputation: 507

The answer in version 2.17 is, that you can just query calculated measures that are assigned to a measure group. See Chris Webb's BI Blog for further informations.

In Version 2.18 this is fixed.

Upvotes: 1

Related Questions