Forum Discussion
QC
Kudo Kingpin
Kudo KingpinUnable to connect Excel Power Query to SAP BW OLAP
Hi team, I am trying to connect Excel/PQ to SAP BW multidimentional data source. I have installed the latest version of SAP BW ODBO driver (64 bit). Using Excel Get Data > From OLEDB option with th...
ToddChitt
Super User
Super UserHonestly, sounds like you are attempting something that is not supported in Excel. Even though Power Query in Excel is pretty close to Power Query in Power BI, it is not EXACTLY the same. You may have found one of those differences.
Question back to you: is your 'Business Warehouse" connumicating with T-SQL language, or something else maybe, like MDX?
QCKudo Kingpin
Kudo KingpinHi Todd, I was able to use MDX query in Power BI to pull data from our BW, so I was attemping to do the same with Excel using SAP ODBO driver ... not sure I am doing it correctly as I am new to this 😄
I found some old articles that seem it is feasible:
https://supportuae.wordpress.com/2013/05/14/connecting-to-sap-bw-with-microsoft-excel/
Thanks!