R Visual Error When Using Cube Hierarchies with SSAS Cube Live connection

[CJ0323]

I've been working with the R visual with a SSAS Cube live connection and I get an error every time I try to input a part of hierarchy into the visual.  already have a hierarchy in my model but I’m unable to load data into R studio. If I take the hierarchy out of the visual I'm able to open R studio and write code fine. I just get this error when trying to a hierarchy or part of a hierarchy.

Are we not able to use hierarchies with the R visual while using a live connection?

[CJ0323]

BUMP

[v-yiruan-msft]

Hi @CJ0323 ,

If I understand correctly, your issue is you got error when create a R visual. And the cause of issue seems to use the hierarchy. To further troubleshoot the issue, could you please provide the following information for further troubleshooting?

1. Provide the error details

2. The applied R scripts for the visual

3.  Create other type of visualization(for example: table visual) using the below fields and check if the table visual can display the data normally

In addition, please check if hit any following limitation:

R visual limitations

SSAS limitations

Best Regards

[CJ0323]

Feedback Type:
Frown (Error)

Timestamp:
2022-12-13T22:09:50.2421834Z

Local Time:
2022-12-13T15:09:50.2421834-07:00

Session ID:
991f0e21-a00e-4b03-9e7f-d40c4d70c1bc

Release:
November 2022

Product Version:
2.111.590.0 (22.11) (x64)

Error Message:
An unexpected error occurred.

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528049]

Peak Virtual Memory:
69.9 GB

Private Memory:
491 MB

Peak Working Set:
835 MB

IE Version:
11.1790.17763.0

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_enableWebView2
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_NlToDax
PBI_horizontalFusion
PBI_optimizeTabRibbon
PBI_relationshipEditPane

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

I'm able to put the same data into a table no problem.

I don't have a script as I'm trying to send the data to Rstudio to build out the RPlots with the data.

Let me know if you need more information.

[CJ0323]

Is this the information needed @v-yiruan-msft ?