{"id":3639,"date":"2021-10-07T09:55:16","date_gmt":"2021-10-07T16:55:16","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3639"},"modified":"2021-10-07T09:55:18","modified_gmt":"2021-10-07T16:55:18","slug":"how-to-increasing-the-timeout-parameters-for-powerbi-odata-feeds","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3639","title":{"rendered":"How to Increasing the Timeout Parameters for PowerBI oData Feeds"},"content":{"rendered":"\n

For particularly large oData exports it can sometimes be helpful to increase the default PowerBI timeout period.<\/p>\n\n\n\n

This is easily done in the advanced editor of the Power Query Editor.<\/p>\n\n\n\n

1) To access the Power Query editor click the options menu on your table and select Edit Query<\/p>\n\n\n\n

2) In Power Query select the Advanced Editor option to edit the advanced query parameters <\/p>\n\n\n\n

3) in the OData.Feed() function add the optional Timeout parameter. The example below is for a 90-minute timeout<\/p>\n\n\n\n

 Source = OData.Feed(\"https:\/\/explore.seeq.com:443\/odata.svc\/Export_67ExampleDataSignals_DataSet\", null, [Implementation=\"2.0\",Timeout=#duration(0, 0, 90, 0)])\n<\/pre>\n\n\n\n
\"Access<\/a><\/figure>\n\n\n\n
\"66029513_oDataQueryDuration.thumb.png.fcb6db8cf5ac487833396fb3c46bd846.png\"\/<\/a>
Ref: https:\/\/www.seeq.org\/index.php?\/forums\/topic\/839-increasing-the-timeout-parameters-for-powerbi-odata-feeds\/<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"
For particularly large oData exports it can sometimes be helpful to increase the default PowerBI timeout period. This is easily done in the advanced editor of the Power Query Editor. 1) To access the Power Query editor click the options menu on your table and select Edit Query 2) In Power Query select the Advanced Editor Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[894,895],"class_list":["post-3639","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-increasing-the-timeout-parameters","tag-increasing-the-timeout-powerbi"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t