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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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

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.