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
Power BI Report Server - SAP HANA Database - Direct Query
Hello, we are using a SAP HANA Database in Power BI Report Server (Vesion January 2020). After we published our report to the Power BI Report Server and try to open the report, we receive the following error message: We receive that error message only if we use the SAP HANA as a multi-dimensional source. If we change the mode into a relational source, the error message doesn´t appear and we are able to open the report without any error. Do you have any idea why it isn´t possible to open the report as multi-dimensional source? Thanks in advance. Kind regards NiHiSAP Hana Database connection - Direct Query mode not working in Power BI Report server
We are able to successfully connect using SAP HANA Database using Power BI desktop version for our PBI Report Server (PBIRS) and publish reports to the Report server. Currently we are only able to use Import mode and draw results into the Power BI desktop and publish them to the Report Server. But our DirectQuery Mode (live connection) reports fail when we run them on our report server. Any suggestions will be appreciated.
