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 KhristianIs Microsoft Power BI authorized to use as analytic tool would be integrated with SAP Business One?
Hello Everyone! We're using SAP Business One as an ERP System, and we want to implement Microsoft Power BI project with SAP Business One, that's will be integrated with SAP Business One (SQL Server Database), but unfortunately, I didn't find anything on the internet about if SAP authorized use Power BI as analytic tool, that's will not be integrated directly with SAP Business One but with SQL Server. Thanks in advance.
