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

Issue creating SAP BW type Data source in PBI Report Server

 

Hello Everyone,

 

I am trying to create SAP BW  type data source in Report Server ( Nov 2017 version)

 

Create_SAP_BW_DS.PNG

 

 

 

But getting error message as - 

 

Error Message.PNGError Message in Report Server - Specified Method Not Supported

 

I am not facing any issues while creating reports  using Power BI Desktop (Oct 2017) for Report Server ( 64 bit)   in Direct-query mode. 

I  have also copied SAP RFC SDK 64 bit library files in C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin. 

 

Any clues what I missed here ?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
guizzi Frequent Visitor
Frequent Visitor

Re: Issue creating SAP BW type Data source in PBI Report Server

Try this string.

 

DataSource=http://serverURL:8000/sap/bw/xml/soap/xmla

View solution in original post

15 REPLIES 15
Moderator v-qiuyu-msft
Moderator

Re: Issue creating SAP BW type Data source in PBI Report Server

Hi @nilesh_shirsat,

 

As you can get data successfully in Power BI desktop optimized for report server, please publish the report to report server. Then go to web portal, click Manage -> Data Sources to check Test Connection to see if connection is successful. 

 

If above connection is ok, then try to create a shared data source use the same connection information. 

 

Best Regards,
Qiuyun Yu

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

Re: Issue creating SAP BW type Data source in PBI Report Server

Hi @v-qiuyu-msft

 

Thank you for replying. 

 

Yes I did try below steps - 

"As you can get data successfully in Power BI desktop optimized for report server, please publish the report to report server. Then go to web portal, click Manage -> Data Sources to check Test Connection to see if connection is successful. "

 

I get below error message - Error Message-Manage Data Source Screen.PNGError Message - Manage Data Source Screen

 

 

 

I have also tried copying SAP RFC SDK library files to 

C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin

C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI\bin

 

It didn't help.

karan7008 Frequent Visitor
Frequent Visitor

Re: Issue creating SAP BW type Data source in PBI Report Server

Hi @nilesh_shirsat@v-qiuyu-msft

 

i am facing exactly the same issue here.

 

May i know the resolution for this. 

 

Regards

Karan 

nilesh_shirsat Regular Visitor
Regular Visitor

Re: Issue creating SAP BW type Data source in PBI Report Server

@v-qiuyu-msft   Do we require to install (copy library files in this case) SAP Netweaver RFC SDK on PBI report server to Register data extension 'SapBusinessWarehouse' ? 

How should install it specific to PBI Report Server ?

 

Many Thanks,

Nilesh

karan7008 Frequent Visitor
Frequent Visitor

Re: Issue creating SAP BW type Data source in PBI Report Server

HI Nilesh 

 

i am able to do so. You need to copy the DLL files in the windows program files folder in the machine where you have installed report server and sql server. 

 

it will work 

 

THanks 

karan 

nilesh_shirsat Regular Visitor
Regular Visitor

Re: Issue creating SAP BW type Data source in PBI Report Server

Thanks Karan for sharing your solution.

 

I have SQL Server and Report Server on different machine both 64 bit. 

did you copy to C:\Program Files\    or   any  sql installation path?

 

I will give it a try next week. 

jjuelke
Advisor

Re: Issue creating SAP BW type Data source in PBI Report Server

how does your RSREPORTSERVER.config look?

do you have others in the list then this:

 

    <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>

 

No Extensionname like "SAPBusinessWarehouse" or?

Thanks!       

 

guizzi Frequent Visitor
Frequent Visitor

Re: Issue creating SAP BW type Data source in PBI Report Server

Try this string.

 

DataSource=http://serverURL:8000/sap/bw/xml/soap/xmla

View solution in original post

Highlighted
jjuelke
Advisor

Re: Issue creating SAP BW type Data source in PBI Report Server

must be specific to your environment, on port 8000 there's no sap endpoint in my environment

Helpful resources

Announcements
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.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 275 members 3,230 guests
Please welcome our newest community members: