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

Question

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.

I still get the follwong error:

DataSource.Error: SAP Business warehouse: RfcInvoke failed (RFC_ABAP_RUNTIME_FAILURE): TIME_OUT

This only works for small data sets of around 5k.

This type of error has been occuring quite often as per the posts/comments I have read.

Is their and y solution to this please.

Thanks.

anonymous · Answer

Anonymous,Have you entered appropriate value in the following timeout textbox?Regards,Lydia

anonymous · Answer

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&nbsp;&nbsp;&nbsp;

anonymous · Answer

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 · Answer

Hi Lydia,Thanks for the prompt response. I added&nbsp;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&nbsp;Thanks

anonymous · Answer

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

Forum Discussion

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

10 Replies

Related content

Warehouse CICD

warehouse vs lakehouse

SQL Server Agent in Fabric Warehouse

Fabric Warehouse Connection in Excel

Warehouse write activity in a Pipeline