Issue creating SAP BW type Data source in PBI Report Server

[Anonymous]

Hello Everyone,

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

But getting error message as - 

Error 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 ?

[guizzi · Accepted solution]

Try this string.

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

[Anonymous]

Changing Connection string format worked for me. 

Also I copied 64 bit version of Netweaver RFC SDK  DLL's to Windows\sytem32 folder  and not 32 bit version. 

[Anonymous]

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

[buddysuper]

http://YOURBWSERVER:8000/sap/bw/xml/soap/xmla

change YOURBWSERVER to IP or DNS name of your bw installation

and  port 80+instance number  (depending of your installation the instance is different than 00)

If you instance  is 50   the port should be: 8050

[Jeab]

Do we need to open any service on SAP BW side in order to use this connection string?

[v-qiuyu-msft]

Hi @Anonymous,

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

[Anonymous]

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

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]

Hi @Anonymous@v-qiuyu-msft

i am facing exactly the same issue here.

May i know the resolution for this. 

Regards

Karan 

[Anonymous]

@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]

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 

[Anonymous]

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!       

[Anonymous]

Yes I do see sapbw extension entry in data node. 

[Anonymous]

for me it still looks like there are datasoure-registrations missing in the current server version?!

If i create a PBI Desktop File which connects by DirectQuery/Import Mode to BW i get a connnection for datasource-type "SapBUsinessWarehouse" published to Report Server wich THROWS error "SapBusinessWarehouse" not registered...

if i try to create a new dataconnection manually in Report Manager the dropdown list shows only "SAPBW" but threre's no "SapBusinessWarehouse" entry at all:

but be really great if someone from the productgroup can give insights on SAPBW vw SapBusinessWarehouse-Extensions differences?!

[buddysuper]

Datasources created in Power BI report server are not used by Power BI Desktop..   Is a shared data source which can be used by SSRS paginated reports and mobiles reports. see link bellow.

To create a Power BI report based on BW , you need to connect to SAP Business Warehouse server  inside of the Power BI desktop by Get Data. 

https://docs.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginate...

In the PBI desktop the report and bw connection works fine,  but after you save in the "Report Server"  the datasource does not connect anymore. It seems to be a product problem... Must be addressed by the "Microsoft IntegrationTeam".

We tried to copy all DLLs from NW 75 in the windows file system , but the problem persists.

[Anonymous]

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.