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

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