cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lakshmikanth Frequent Visitor
Frequent Visitor

unable to connect power BI with SAP BW

Hi Power BI experts,

 

I have issue in connecting my SAP BW system with power BI gate ways, please find the details.

 

 

What i have done sofar

 

1.I have installed .net connector

2.Then using SAP BW ware house connection i have succesfull able to connect SAP BW bex queries and model the data in power BI desk top

3.Then i have saved the report and published the report which returned with no gate way acess to data source

4.Then i have succesfully installed SAP gate way cluster and it says online---you can only get started

5.I have installed SAP 7.5 RFC netweaver libary menyioned in the SAP note 1025361, copied dll files from lib folder and placed it in cdrive---windows---system 32

 

What i am unable to achieve

 

1.When i try adding data source with option sap buisness warehouse and provided, server instance clinet and user ID and password details and now i get the error message

 

Cannot connect: An error has occurred while connecting to. Details: Cannot register this data source for gateway instances in this cluster. For more information about specific errors for each gateway instance, see below. show details

Troubleshoot connection issues

Can some one help?

 

 

BR
LakshmikantpowerBI error.png

5 REPLIES 5
Community Support Team
Community Support Team

Re: unable to connect power BI with SAP BW

Hi @lakshmikanth,

 

Did install the SAP Drivers and PBI Desktop into 64 bits version? By the way, can you please provide more detail content about this issue?

 

Regards,

Frank

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

Re: unable to connect power BI with SAP BW

Hi @lakshmikanth,

 

Did install the SAP Drivers and PBI Desktop into 64 bits version? By the way, can you please provide more detail content about this issue?

 

Regards,

Frank

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

Re: unable to connect power BI with SAP BW

Hello Frank,

 

thanks for your reply

 

1.I am using Power BI desktop version 2.65.5313.1381 64-bit (desember 2018)

2.I have downloaded 64 bit version SAP NW RFC SDK 7.50 library from the below link link, please see the first screen shot

 

https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVEN...

 

SAP NW RFC SDK 7.50 X64bit windows.png

 

3.I have copied dll filtes from the downlaled SAP RFC libarary from step 2

 

 

SAP RFC Dll files.png

 

4.Pasted the copied files in step 3 in to c----windows---system32folder

 

windows32.png

 

5.Then  created a gate and tried adding data source which gave us the error.

 

BR

Lakshmikanth

 

lakshmikanth Frequent Visitor
Frequent Visitor

Re: unable to connect power BI with SAP BW

Can some one help on this please?

mhum Frequent Visitor
Frequent Visitor

Re: unable to connect power BI with SAP BW

I have a similar issue - did you find a solution yet? 

 

Thanks and BR

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 293 members 2,967 guests
Please welcome our newest community members: