calculated dimensions from cubes to PBI

[mlaiks]

Hi, I'm facing a strange issue when developing a cube using Visual Studio:

I created calculated members in dimension hierarchies but I can't see them in Power Bi.

How can I do it?

[v-sihou-msft]

@mlaiks

I suggest you use live connection to SSAS database. The calculated measure and members will be loaded into Power BI properly. But those created hierarchies and members will appear in another table, not in the initial dimension table.

 

[mlaiks]

@v-sihou-msft

I'm using live connection to do it, but it doesn't appear in PBI interface. Are there some limitations or did I make something wrong?

Should this procedure be valid only for date type or it is also valid for every data type?

I also created additional dimensions without declaring it as NULL and then replacing its definition using SCOPE clause: is it mandatory?