Using Multidimensional Cube and connecting live connection in Power BI desktop

[Anonymous]

Hi ,

We are using Multidimensional Cube and connecting live connection in Power BI for report creation in Power BI desktop. 

1) When applied year level hierarchy data coming and matching in both end Cube browse mode and Power BI report for measures 

2) When applied Quarter level hierarchy data coming and matching in both end Cube browse mode and Power BI report for measures 

But below issue we are facing with MD measures in Power BI desktop.

3) When applied month level hierarchy data not matching in both end Cube browse mode and Power BI report for same measures.

Some one please let us know which are the possible ways to correct this above problem with MD measures. Solution really Appricated  

Thanks 

Ravi Jain

[v-yulgu-msft]

Hi @Anonymous,

It looks like a limitation of live connection to SSAS from Power BI desktop. Please check whether the date hierarchy shows correct values with import mode.

Regards,

Yuliana Gu