Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Get Data from SAP BW Query - DataSource.Error: SAP Business warehouse: RfcInvoke failed...

I am on the latest update (Dec 2017) of PBI Desktop.   Trying to get data fro  SAP BW query. The request times out. Our Basis Team have increased the timeout in SAP BW Server side bur no effect.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Have you entered appropriate value in the following timeout textbox?


Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the response. But I don't get the option of 'timeout' in Advanced Options. It only gives 'Language Code' and 'MDX' options. Cannot paste a pic.

    Thanks

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous，

      Directly add Timeout value in Advanced Editor of your query and check if you get errors.

      [Timeout=#duration(0,0,30,0)]



      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Lydia,

        Thanks for the prompt response. I added timeout value in Advanced Editor. I get a different error:

        DataSource.Error: SAP Business Warehouse: This function doesn't support the query option 'Timeout' with value '#duration(0, 0, 30, 0)'.
        Details:
        0.00:30:00

         

        Thanks