04-11-2017 08:42 PM
I'm using: Power BI Desktop (April 17 release) I'm trying to connect to SAP BW using the now standard SAP Business Warehouse server connector. SAP NW RFC SDK 7.20 downloaded and extracted. The .lib and .dll files all plonked into my system32 folder. When I use the connector I can see the Cubes in BW okay but when I preview or import I get an error message:
DataSource.Error: SAP Business Warehouse: Invalid MDX command with Details: DataSourceKind=SapBusinessWarehouse DataSourcePath=drapppsap30/16/510 ErrorCode=-2147467259 Any ideas ?
04-13-2017 06:47 PM
04-19-2017 12:28 AM
04-19-2017 02:11 AM
I downloaded the 17-04-2017 released update of PBI as you suggested. Still i am not able to access any report or Cube in SAP BW. Kindly tell me a way so that i can share the trace logs as you suggested. I have one with me.
04-19-2017 03:04 AM
Since i am on a my office vpn so i cannot acceess cloud storage of any kind. It would be great if you can drop me a test mail to my personal mail id i.e firstname.lastname@example.org , I can send you zip file of the trace log folder.
04-25-2017 09:34 PM
I've been on vacation, just back now.
I'm still having issues. I've put the relevant log files relating to the error on onedrive at the link below.
NB. Since I created these files I did another install of PBI desktop to get up to v 2.45.4704.722 but still the same error.
04-26-2017 01:33 AM