Forum Discussion

mlaiks's avatar
mlaiks
Frequent Visitor
10 years ago

calculated dimensions from cubes to PBI

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?
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    mlaiks
    Frequent Visitor
    10 years ago

    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?