cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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 in Report Server - Specified Method Not SupportedError 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
Highlighted
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
Highlighted
Community Support
Community Support

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.
Highlighted
Resolver I
Resolver I

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

Highlighted
Regular 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 

Highlighted
Resolver I
Resolver I

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

Highlighted
Regular 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 

Highlighted
Resolver I
Resolver I

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. 

Highlighted
Helper II
Helper II

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!       

 

Highlighted
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
Helper II
Helper II

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
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors