Essbase connector

[KTE]

Dear all, 

I am new to Power BI. I am currently using Power BI Desktop (free version). 

I was able to connect Essbase to Power BI and select a cube where it should retrieve the data from. It shows me all the dimensions of the cube under fields. But when expanding a dimension it gives me weird descriptions: 

e.g. the children of the dimension ENITY are called Entity.[Entity].Level 1 or Entity.[Entity].Level 1.Unique Name

the children of the dimension FISCAL YEAR are called Fiscal Year.Level 1 etc. 

I was also not able to tranform the data or organize it. Why are there such strange labels and how can I change it? 

e.g. when expanding FISCAL Year I would like to see 2021, 2020, 2019 etc. 

Thank you for your help!

Regards, 

Kathi 

[v-kelly-msft]

Hi  @KTE ,

Can you rename the field?

Check below vedio for help:

https://www.youtube.com/watch?v=A0aXdXMLvHM

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!