cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Khristian Regular Visitor
Regular Visitor

SAP Connection

Hi everyone.

 

To connect PBI to SQL the domain most be equal.

 

For SAP BW and PBI is the same rule?

 

Regards

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: SAP Connection

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

TORNALLY Frequent Visitor
Frequent Visitor

Re: SAP Connection

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

View solution in original post

3 REPLIES 3
djnww Established Member
Established Member

Re: SAP Connection

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

Re: SAP Connection

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

TORNALLY Frequent Visitor
Frequent Visitor

Re: SAP Connection

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

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)