SAP Connection

[Khristian]

Hi everyone.

To connect PBI to SQL the domain most be equal.

For SAP BW and PBI is the same rule?

Regards

[v-yuezhe-msft · Accepted solution]

Hi @Khristian，

When connecting to SQL Server database from Power BI Desktop, SQL Server and Power BI Desktop don’t have to be located at the machines that are in same domain. As long as you can ping to the machine that installing SQL Server from the machine that installing Power BI Desktop, and you configure SQL Server properly, you are able to use Database credential in Power BI Desktop to connect to SQL Server database, or you can use Windows credential and runas /netonly command to connect to the target SQL Server database in Power BI Desktop.

Besides, when connecting about SAP BW in Power BI Desktop, it requires Database credential where you need to put username and Password. From my point of perspective, the connection process is similar to that we use Database credential in Power BI Desktop to connect to SQL Server, Power BI Desktop and SAP BW don’t have to be in same domain.  I would recommend you use BEx Query Designer to simulate this connection process, then connect to SAP BW in Power BI Desktop.

Thanks,
Lydia Zhang

[TORNALLY · Accepted solution]

Khristian, one way to approach SAP data for Power BI is with the Simplement Data Liberator.  Check it out:

              www.simplement.us

This SQL Server-based platform surfaces any necessary table, cluster, Pool table or domain in real time, and effortlesly!

   Mike McNally

mmcnally@simplment.us

[v-yuezhe-msft · Accepted solution]

Hi @Khristian，

When connecting to SQL Server database from Power BI Desktop, SQL Server and Power BI Desktop don’t have to be located at the machines that are in same domain. As long as you can ping to the machine that installing SQL Server from the machine that installing Power BI Desktop, and you configure SQL Server properly, you are able to use Database credential in Power BI Desktop to connect to SQL Server database, or you can use Windows credential and runas /netonly command to connect to the target SQL Server database in Power BI Desktop.

Besides, when connecting about SAP BW in Power BI Desktop, it requires Database credential where you need to put username and Password. From my point of perspective, the connection process is similar to that we use Database credential in Power BI Desktop to connect to SQL Server, Power BI Desktop and SAP BW don’t have to be in same domain.  I would recommend you use BEx Query Designer to simulate this connection process, then connect to SAP BW in Power BI Desktop.

Thanks,
Lydia Zhang

[djnww]

The only reason I'm commenting here is because I'm very curious to know who has successfully done this?