Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

mmegnia

SQL2014 SSAS Multidimensional Data Source Results in Many Disabled Power BI Features

Submitted by on ‎02-28-2018 10:28 AM

I am trying to figure out if this is just a versioning issue, or if we need to switch to tabular SSAS.

 

We are running Microsoft SQL Server 2014 - 12.0.4100.1 (X64) SSAS in Multidimensional mode.  But when we connect Power BI to any of our cubes, many features get disabled such as:

 

  • You cannot create calculated measures
  • You cannot change the aggregation method on a measure
  • You cannot join in other data sources

Is this by design?  I can't find anything online indicating other people are having these issues.  Would this be fixed if I upgrade to 2016 or do I need to switch to tabular to have the full capabilities of Power BI?

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎03-01-2018 10:18 PM

Hi @mmegnia,

 

From your description, it seems you get data from SSAS multidimensional model in a live connection, right? 

 

If it's live connection to SSAS multidimensional model, it's by design. You can vote on below ideas: 

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140907-create-calculated-column...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12532173-ssas-get-data-multiple-d...

 

Best Regards,
Qiuyun Yu 

Idea Statuses