Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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')."
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.