Forum Discussion
SAP BW timeout option, runtime errorcode 2147467259
Ok, understood. But I am no longer with access to SAP BW server. I asked my coworker to try and enable trace log while performing the data load. As soon as I have the trace log file, I will share it here.
About the timeout option, there is an option to set timeout command, according to this March update.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-update-feature-summary/
But where should I use this command? Inside the MDX box?
What are the correct syntax and parameters?
Could someone please provide an example of this command?
Hi Anonymous,
In the blog, it said you get data from SQL Server database. We can add T-SQL command under the “Advanced options” section in data source dialogs. For example, we can use T-SQL @@LOCK_TIMEOUT function to set the timeout.
Best Regards,
Angelia