R Visual and Hierarchies do not work with SSAS Cube Live connection?

[CJ0323]

I've been working with the R visual with a Cube live connection and I get an error everytime i try to input a part of hierarchie(I've also tried putting the whole Hierarchie and get an error as well.) Are we not able to use hierarchies with the R visual?

Thank you!

[v-zhangti]

Hi, @CJ0323 

No built-in date hierarchy is not available in Direct Query as well as Live connection mode. It will be beneficial if the SSAS model itself has a date hierarchy implemented there. 

For reference:
Create Power BI visuals using R - Power BI | Microsoft Learn

Solved: R Script Visual error - Can't find R - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CJ0323]

So I already have a hierarchy in my model and i'm trying to use it as input into the R visual. Its unable to load data into R but is able to load data into a table just fine. My question is, is R visual able to take in a hierarchy  for input or is that feature unavailable for Live connection?