Forum Discussion
SisterRay
3 years agoFrequent Visitor
Unknown error when executing MDX, BRAINOLAPAPI 012 (Power BI Desktop & SAP BW)
Hi all, I can connect to data source - SAP BW but each time I'm getting an "Unknown error when executing MDX." (DataSource.Error is below). When I use the connector I can see the Cubes in BW okay...
ToddChitt
3 years agoSuper User
Sounds like you are executing an MDX query instead of a T-SQL query. Is that query mal-formed? If you paste it into a browsing tool does it return rows?
SisterRay
3 years agoFrequent Visitor
This issue is only on Power BI side.
When I use the connector I can see the Cubes in BW okay but when I import data I get this error:
DataSource.Error: The SAP BW server reported an error: 'Unknown error when executing MDX'. To find more information about this error, visit the SAP support site and search for 'BRAINOLAPAPI 012'.
Details: DataSourceKind=SapBusinessWarehouse
- NB_1501_2 years agoNew Member
I have the same issue, was there a solution on this error message?