Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
i still have this case too, any solution or update about this case ?
@mfhussain,
Do you get errors if you use DirectQuery mode to connect to the SAP data source?
Regards,
Lydia
Hi Lydia,
I can connect using Direct Query mode. It brings in the table/fileds in PBI desktop, but when retrieving data I get the same error of RFC tiemout.
Thanks
mf
@mfhussain,
I would recommend you open a support ticket on the support.powerbi.com site.
Regards,
Lydia
@mfhussain,
Have you entered appropriate value in the following timeout textbox?
Regards,
Lydia
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
@mfhussain,
Directly add Timeout value in Advanced Editor of your query and check if you get errors.
[Timeout=#duration(0,0,30,0)]
Regards,
Lydia
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
@mfhussain,
Do you check if there is syntax error? I can add the Timeout value successfully.
Regards,
Lydia
Though I am not getting any syntax error but getting the other error of timeout proerty not found.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |