https://community.fabric.microsoft.com/t5/Report-Server/PBI-vs-SAP/m-p/4680106#M40545 <P>Hi All,</P><P>&nbsp;</P><P>Do you know how to conect form Power BI Report to SAP data base?</P><P>&nbsp;</P><P>I would highly appriciate your support <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 05 May 2025 11:14:14 GMT S-a 2025-05-05T11:14:14Z https://community.fabric.microsoft.com/t5/Report-Server/PBI-vs-SAP/m-p/4680106#M40545 <P>Hi All,</P><P>&nbsp;</P><P>Do you know how to conect form Power BI Report to SAP data base?</P><P>&nbsp;</P><P>I would highly appriciate your support <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 05 May 2025 11:14:14 GMT https://community.fabric.microsoft.com/t5/Report-Server/PBI-vs-SAP/m-p/4680106#M40545 S-a 2025-05-05T11:14:14Z https://community.fabric.microsoft.com/t5/Report-Server/PBI-vs-SAP/m-p/4680478#M40551 <P>Yes, you can connect Power BI Report Server to various SAP data sources. The two most common SAP systems used are:</P><UL><LI><STRONG>SAP HANA</STRONG> – In-memory database commonly used with Power BI.</LI><LI><STRONG>SAP BW (Business Warehouse)</STRONG> – Typically used with MDX or OLE DB for OLAP.</LI></UL><H3>1. <U>For SAP HANA</U></H3><P><STRONG>Requirements:</STRONG></P><UL><LI>Install SAP HANA ODBC driver on the Power BI Report Server machine.</LI><LI>Use the <STRONG>DirectQuery</STRONG> mode for live connection, or import data.</LI></UL><P><STRONG>Steps:</STRONG></P><OL><LI>Open Power BI Desktop (Optimized for Report Server).</LI><LI>Click Get Data → More... → Search for <STRONG>SAP HANA</STRONG>.</LI><LI>Enter server name (e.g., hana.server.local:30015).</LI><LI>Choose <STRONG>Import</STRONG> or <STRONG>DirectQuery</STRONG> and log in using SAP credentials.</LI><LI>Build the report and publish to Power BI Report Server.</LI></OL><H3>2. <U>For SAP BW</U></H3><P><STRONG>Requirements:</STRONG></P><UL><LI>Install <STRONG>SAP NetWeaver RFC SDK</STRONG> and <STRONG>SAP BW Connector</STRONG>.</LI><LI>Power BI Desktop (Report Server edition) must match the connector version.</LI></UL><P><STRONG>Steps:</STRONG></P><OL><LI>Open Power BI Desktop (RS edition) → Get Data → SAP Business Warehouse Server.</LI><LI>Provide BW server address and credentials.</LI><LI>Choose InfoProvider or BEx query as source.</LI><LI>Transform and model data as needed, then publish to Report Server.</LI></OL><H3>Resources:</H3><UL><LI><A href="https://learn.microsoft.com/en-us/power-bi/report-server/connect-data-source" target="_blank" rel="noopener">Power BI Report Server - Connect to data sources</A></LI><LI><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana" target="_blank" rel="noopener">Connect to SAP HANA in Power BI</A></LI><LI><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sap-bw" target="_blank" rel="noopener">Connect to SAP BW in Power BI</A></LI></UL><P>&nbsp;</P><CENTER><TABLE border="1" cellspacing="0" cellpadding="10"><TBODY><TR><TD><P><FONT color="#2e7d32"><STRONG><span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span>If my message helped solve your issue, please mark it as <I>Resolved</I>!</STRONG> </FONT></P><P><FONT color="#1565c0"><STRONG><span class="lia-unicode-emoji" title=":thumbs_up:">👍</span>If it was helpful, consider giving it a <I>Kudos</I>!</STRONG> </FONT></P></TD></TR></TBODY></TABLE></CENTER> Mon, 05 May 2025 13:30:05 GMT https://community.fabric.microsoft.com/t5/Report-Server/PBI-vs-SAP/m-p/4680478#M40551 SolomonovAnton 2025-05-05T13:30:05Z