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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

        Do you check if there is syntax error? I can add the Timeout value successfully.

        Regards,
        Lydia