{"id":34563,"date":"2024-08-23T13:37:10","date_gmt":"2024-08-23T11:37:10","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=34563"},"modified":"2024-08-23T14:32:59","modified_gmt":"2024-08-23T12:32:59","slug":"power-bi-scheduled-refresh-stuck","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/","title":{"rendered":"Power BI &#8211; Scheduled refresh stuck"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-introduction\"><strong>Introduction<\/strong><\/h2>\n\n\n\n<p>When creating reports, there are several modes through which we can import data. In our case, reports had been created using the &#8220;import mode.&#8221; In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards.<\/p>\n\n\n\n<p>Once the report is published, the data presented by the report is not automatically updated. Therefore, if data is added between the moment the report is published and the report is displayed, it will not be accessible or visible to the end users.<\/p>\n\n\n\n<p>Here are some details:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I create my report<\/li>\n\n\n\n<li>I connect to my datasource<\/li>\n\n\n\n<li>I choose the &#8220;import mode&#8221; to import my data<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"322\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png\" alt=\"\" class=\"wp-image-34564\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png 654w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21-300x148.png 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From what we can see (via this mode), Power BI will call the Microsoft SQL Server Analysis Services to load the data into memory (Power BI launches an instance of SSAS through a separate process).<\/li>\n<\/ul>\n\n\n\n<p>We can observe this:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start of data loading via SSAS<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"272\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-22.png\" alt=\"\" class=\"wp-image-34565\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-22.png 748w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-22-300x109.png 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data is being loaded via SSAS<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"322\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-23.png\" alt=\"\" class=\"wp-image-34566\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-23.png 732w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-23-300x132.png 300w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"358\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-24.png\" alt=\"\" class=\"wp-image-34567\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-24.png 470w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-24-300x229.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/figure>\n\n\n\n<p>Changes are then made to how data is structured and organized (through xVelocity, VertiPaq).<\/p>\n\n\n\n<p>Thus, it is necessary to load the entire dataset before being able to query it. The problem arises when the report has been published and the data is updated after publication. When the report is run, it does not reflect the changes made after its publication.<\/p>\n\n\n\n<p>Here is an example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>My report queries the LinkTypes table, which has 2 types of links: &#8220;Linked&#8221; and &#8220;Duplicate&#8221;<\/li>\n\n\n\n<li>Once published, I can see a table displaying this data<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"408\" height=\"264\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-25.png\" alt=\"\" class=\"wp-image-34568\" style=\"width:408px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-25.png 408w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-25-300x194.png 300w\" sizes=\"auto, (max-width: 408px) 100vw, 408px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I add a new row to the LinkTypes table<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"216\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-26.png\" alt=\"\" class=\"wp-image-34569\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-26.png 576w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-26-300x113.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A new run of the report does not display this data<\/li>\n<\/ul>\n\n\n\n<p>To address this issue, it is possible to create scheduled refreshes to update the data and ensure the report has up-to-date information.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"334\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-27-1024x334.png\" alt=\"\" class=\"wp-image-34571\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-27-1024x334.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-27-300x98.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-27-768x251.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-27.png 1048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-problem\"><strong>What is the problem?<\/strong><\/h2>\n\n\n\n<p>In the case of our client, the scheduled refreshes were not occurring and remained stuck in the &#8220;in progress&#8221; or &#8220;refresh in progress&#8221; state. As a result, the reports did not have up-to-date data.<\/p>\n\n\n\n<p>To understand the origin of the problem, we tried to analyze logs:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We checked the Power BI logs. However, we found nothing. There were no errors (no timeouts, no exceptions, etc)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"464\" height=\"270\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-28.png\" alt=\"\" class=\"wp-image-34572\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-28.png 464w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-28-300x175.png 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The event viewer of the server hosting the Power BI service<\/li>\n\n\n\n<li>The SQL Server error log that hosts the Power BI databases<\/li>\n\n\n\n<li>SQL Server waits<\/li>\n\n\n\n<li>Extended events<\/li>\n\n\n\n<li>The jobs created by Power BI (which correspond to the scheduled refreshes) did not return any errors<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-functioning-model-of-scheduled-refresh\"><strong>The functioning model of scheduled refresh<\/strong><\/h2>\n\n\n\n<p>To understand where the problem might be coming from, we need to analyze what happens when a scheduled refresh is requested.<\/p>\n\n\n\n<p>When a scheduled refresh is requested, here are some of the operations that occur:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The stored procedure &#8220;AddEvent&#8221; is called. This procedure inserts a row into the &#8220;Event&#8221; table:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"260\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-29.png\" alt=\"\" class=\"wp-image-34573\" style=\"width:600px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-29.png 600w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-29-300x130.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"676\" height=\"128\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-30.png\" alt=\"\" class=\"wp-image-34574\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-30.png 676w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-30-300x57.png 300w\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A row is added to the &#8220;Event&#8221; table<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1012\" height=\"34\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-31.png\" alt=\"\" class=\"wp-image-34575\" style=\"width:902px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-31.png 1012w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-31-300x10.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-31-768x26.png 768w\" sizes=\"auto, (max-width: 1012px) 100vw, 1012px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"968\" height=\"56\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-32.png\" alt=\"\" class=\"wp-image-34576\" style=\"width:910px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-32.png 968w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-32-300x17.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-32-768x44.png 768w\" sizes=\"auto, (max-width: 968px) 100vw, 968px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Power BI is notified that data needs to be updated<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"199\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-33-1024x199.png\" alt=\"\" class=\"wp-image-34577\" style=\"width:919px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-33-1024x199.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-33-300x58.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-33-768x149.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-33.png 1338w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The status of the subscription is updated (the value of the &#8220;@Status&#8221; is in Fench because I triggered a scheduled refresh through a web browser that uses French language)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"130\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-34.png\" alt=\"\" class=\"wp-image-34578\" style=\"width:923px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-34.png 758w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-34-300x51.png 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"60\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-35.png\" alt=\"\" class=\"wp-image-34579\" style=\"width:814px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-35.png 604w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-35-300x30.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"162\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-36-1024x162.png\" alt=\"\" class=\"wp-image-34580\" style=\"width:891px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-36-1024x162.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-36-300x48.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-36-768x122.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-36.png 1060w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Other objects are then updated, such as the notifications table. The Event table is also updated to remove the corresponding event :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The TakeEventFromQueue is a stored procedure that calls a delete operation<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"440\" height=\"36\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-37.png\" alt=\"\" class=\"wp-image-34581\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-37.png 440w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-37-300x25.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"32\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-38-1024x32.png\" alt=\"\" class=\"wp-image-34582\" style=\"width:896px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-38-1024x32.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-38-300x9.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-38-768x24.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-38.png 1142w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-problem-resolution\"><strong>Problem Resolution<\/strong><\/h2>\n\n\n\n<p>In our client&#8217;s case, the Events table contained data, but actions to execute a scheduled refresh were not adding any rows to the Event table. We decided to clear the contents of the Events table after backing up the database. After this action, the reports started updating correctly.<\/p>\n\n\n\n<p>Thank you, Amine Haloui.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the &#8220;import mode.&#8221; In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards. Once the report is published, the [&hellip;]<\/p>\n","protected":false},"author":147,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294,99],"tags":[1490],"type_dbi":[],"class_list":["post-34563","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-sql-server","tag-power-bi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Power BI - Scheduled refresh stuck - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI - Scheduled refresh stuck\" \/>\n<meta property=\"og:description\" content=\"Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the &#8220;import mode.&#8221; In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards. Once the report is published, the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-23T11:37:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-23T12:32:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png\" \/>\n<meta name=\"author\" content=\"Amine Haloui\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amine Haloui\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\"},\"author\":{\"name\":\"Amine Haloui\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe\"},\"headline\":\"Power BI &#8211; Scheduled refresh stuck\",\"datePublished\":\"2024-08-23T11:37:10+00:00\",\"dateModified\":\"2024-08-23T12:32:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\"},\"wordCount\":604,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png\",\"keywords\":[\"Power BI\"],\"articleSection\":[\"Business Intelligence\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\",\"name\":\"Power BI - Scheduled refresh stuck - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png\",\"datePublished\":\"2024-08-23T11:37:10+00:00\",\"dateModified\":\"2024-08-23T12:32:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png\",\"width\":654,\"height\":322},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI &#8211; Scheduled refresh stuck\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe\",\"name\":\"Amine Haloui\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g\",\"caption\":\"Amine Haloui\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/aminehaloui\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI - Scheduled refresh stuck - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/","og_locale":"en_US","og_type":"article","og_title":"Power BI - Scheduled refresh stuck","og_description":"Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the &#8220;import mode.&#8221; In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards. Once the report is published, the [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/","og_site_name":"dbi Blog","article_published_time":"2024-08-23T11:37:10+00:00","article_modified_time":"2024-08-23T12:32:59+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png","type":"","width":"","height":""}],"author":"Amine Haloui","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Amine Haloui","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/"},"author":{"name":"Amine Haloui","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe"},"headline":"Power BI &#8211; Scheduled refresh stuck","datePublished":"2024-08-23T11:37:10+00:00","dateModified":"2024-08-23T12:32:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/"},"wordCount":604,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png","keywords":["Power BI"],"articleSection":["Business Intelligence","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/","url":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/","name":"Power BI - Scheduled refresh stuck - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png","datePublished":"2024-08-23T11:37:10+00:00","dateModified":"2024-08-23T12:32:59+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/image-21.png","width":654,"height":322},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-scheduled-refresh-stuck\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI &#8211; Scheduled refresh stuck"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/221331d69d49c63fca67069b49b813fe","name":"Amine Haloui","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64707272207cd8d2667aefcb212f3ff5d19a15813da5aad6553f109d1f1afec1?s=96&d=mm&r=g","caption":"Amine Haloui"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/aminehaloui\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/147"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=34563"}],"version-history":[{"count":5,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34563\/revisions"}],"predecessor-version":[{"id":34587,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/34563\/revisions\/34587"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=34563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=34563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=34563"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=34563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}