Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

SAP BW timeout option, runtime errorcode 2147467259

I can connect to my SAP Business Warehouse server. I used this tutorial, setting Environment Variables:  https://wiki.scn.sap.com/wiki/display/ABAPConn/Download+and+Installation+of+NW+RFC+SDK   Wh...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Anonymous,

Please enable the Power BI desktop trace log, then repeat the steps to connect to SAP BW, share the trace file with us. You can upload files to OneDrive and share the link here.
 
Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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