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.

  • 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