Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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)         But getting error message as -      I am not facing any issues w...
Report Server On premises
sap bw
  • guizzi's avatar
    guizzi
    8 years ago

    Try this string.

     

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

karan7008's avatar
karan7008
Regular Visitor
8 years ago

Hi Anonymousv-qiuyu-msft

 

i am facing exactly the same issue here.

 

May i know the resolution for this. 

 

Regards

Karan 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    karan7008
    Regular Visitor
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        8 years ago

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