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

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

 

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.