SAP B1 Report to PowerBI
Hey Experts, Currently we have been trying to set-up a PowerBI Dashboard with Live SQL query to SAP. However, the information we want to use in the dashboard is from an overview in SAP. We believe that this SAP overview is build with multiple SAP queries. My question is as following, how can we know which queries are used in SAP B1 to create the overview OR how can we connect PowerBI directly to this overview. Thank you kindly in advance,
SAP B1 and Power BI connection ERROR- since new update
Hi All, I used to connect to SAP B1 and get all tables from the HANA database using ODBC power BI connector(It had an option of SAP HANA database). However since the update, ODBC do not have an option of SAB HANA database. Therefore I have to connect using SAP HANA DATABASE connector, but instead of tables, i get SAP views as below: Please help and advise how I can get SAP HANA database tables, such as ORDR or RDR1 etc once connection is established instead of views or functions. Thank you #sap #powerbi pbi_user_rdg Khristian
