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 - 

 

Error Message in Report Server - Specified Method Not Supported

 

I am not facing any issues while creating reports  using Power BI Desktop (Oct 2017) for Report Server ( 64 bit)   in Direct-query mode. 

I  have also copied SAP RFC SDK 64 bit library files in C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin. 

 

Any clues what I missed here ?

 

 

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

15 Replies

  • guizzi's avatar
    guizzi
    Frequent Visitor
    8 years ago

    Try this string.

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Changing Connection string format worked for me. 

       

      Also I copied 64 bit version of Netweaver RFC SDK  DLL's to Windows\sytem32 folder  and not 32 bit version. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      must be specific to your environment, on port 8000 there's no sap endpoint in my environment

      • buddysuper's avatar
        buddysuper
        Regular Visitor
        8 years ago

         

        http://YOURBWSERVER:8000/sap/bw/xml/soap/xmla

         

        change YOURBWSERVER to IP or DNS name of your bw installation

        and  port 80+instance number  (depending of your installation the instance is different than 00)

         

        If you instance  is 50   the port should be: 8050

         

  • 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