Data Cube Import Issues

[nawillia711]

I am having an issue connecting to a data cube using the SQL Server Analysis Services database connection. This is the appropriate connection, but when I am trying to import specific measure points using a MDX query then it returns the following error:

Details: "AnalysisServices: Internal error: An unexpected error occurred (file 'dmxinit.cpp', line 275, function 'DMXNodeSelect::InitFromASTSelect')."

[v-shex-msft]

HI @nawillia711 ,

AFAIK, if you want to use or import AS measure on Power Bi side, you need to use live connection mode. (this mode will disable query editor operations and most of edit features on power bi desktop)

I don't think it is possible to import MDX formula to query editor side with import mode, power bi will broken orignal table structure(data field types and relationships) and fix measure calculation as static value and convert them to columns.

Regards,

Xiaoxin Sheng