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

Issue creating SAP BW type Data source in PBI Report Server

Anonymous — Fri, 26 Jan 2018 22:40:55 GMT

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 ?

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

v-qiuyu-msft — Mon, 29 Jan 2018 09:15:13 GMT

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

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

Anonymous — Mon, 29 Jan 2018 15:38:25 GMT

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.

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

karan7008 — Fri, 02 Feb 2018 05:52:58 GMT

Hi @Anonymous@v-qiuyu-msft

i am facing exactly the same issue here.

May i know the resolution for this.

Regards

Karan

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

Anonymous — Tue, 06 Feb 2018 20:40:19 GMT

@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

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

karan7008 — Thu, 15 Feb 2018 06:56:34 GMT

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

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

Anonymous — Sat, 17 Feb 2018 00:47:36 GMT

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.

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

Anonymous — Tue, 06 Mar 2018 15:50:56 GMT

how does your RSREPORTSERVER.config look?

do you have others in the list then this:

No Extensionname like "SAPBusinessWarehouse" or?

Thanks!

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

guizzi — Tue, 06 Mar 2018 19:34:36 GMT

Try this string.

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

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

Anonymous — Wed, 07 Mar 2018 07:26:59 GMT

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

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

Anonymous — Wed, 07 Mar 2018 07:32:47 GMT

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

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

buddysuper — Wed, 07 Mar 2018 16:01:18 GMT

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

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

buddysuper — Wed, 07 Mar 2018 16:24:04 GMT

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-paginated-reports

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.

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

Anonymous — Thu, 08 Mar 2018 18:29:25 GMT

Yes I do see sapbw extension entry in data node.

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

Anonymous — Thu, 08 Mar 2018 18:31:09 GMT

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.

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

Jeab — Fri, 20 Jul 2018 11:52:38 GMT

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