{"id":227,"date":"2023-02-04T14:01:27","date_gmt":"2023-02-04T13:01:27","guid":{"rendered":"https:\/\/www.syntera.ch\/blog\/?p=227"},"modified":"2023-02-07T16:33:47","modified_gmt":"2023-02-07T15:33:47","slug":"incorrect-power-bi-report-data-after-refresh","status":"publish","type":"post","link":"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/","title":{"rendered":"Incorrect Power BI Report Data After Refresh"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-f56f613f wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-post-author has-medium-font-size\"><div class=\"wp-block-post-author__avatar\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=48&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&#038;d=mm&#038;r=g 2x' class='avatar avatar-48 photo' height='48' width='48' \/><\/div><div class=\"wp-block-post-author__content\"><p class=\"wp-block-post-author__byline\">LEAD DATA ENGINEERING<\/p><p class=\"wp-block-post-author__name\">Dominic Schranz<\/p><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-outermost-social-sharing alignright has-small-icon-size has-icon-color is-style-logos-only is-content-justification-left is-layout-flex wp-container-outermost-social-sharing-is-layout-fa5e4718 wp-block-outermost-social-sharing-is-layout-flex\"><li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-linkedin has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2023%2F02%2F04%2Fincorrect-power-bi-report-data-after-refresh%2F&#038;title=Incorrect%20Power%20BI%20Report%20Data%20After%20Refresh\" aria-label=\"Share on LinkedIn\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M19.7,3H4.3C3.582,3,3,3.582,3,4.3v15.4C3,20.418,3.582,21,4.3,21h15.4c0.718,0,1.3-0.582,1.3-1.3V4.3 C21,3.582,20.418,3,19.7,3z M8.339,18.338H5.667v-8.59h2.672V18.338z M7.004,8.574c-0.857,0-1.549-0.694-1.549-1.548 c0-0.855,0.691-1.548,1.549-1.548c0.854,0,1.547,0.694,1.547,1.548C8.551,7.881,7.858,8.574,7.004,8.574z M18.339,18.338h-2.669 v-4.177c0-0.996-0.017-2.278-1.387-2.278c-1.389,0-1.601,1.086-1.601,2.206v4.249h-2.667v-8.59h2.559v1.174h0.037 c0.356-0.675,1.227-1.387,2.526-1.387c2.703,0,3.203,1.779,3.203,4.092V18.338z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on LinkedIn\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-mail has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"mailto:?subject=Incorrect%20Power%20BI%20Report%20Data%20After%20Refresh&#038;body=Incorrect%20Power%20BI%20Report%20Data%20After%20Refresh%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2023%2F02%2F04%2Fincorrect-power-bi-report-data-after-refresh%2F\" aria-label=\"Email this Page\"  class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M20,4H4C2.895,4,2,4.895,2,6v12c0,1.105,0.895,2,2,2h16c1.105,0,2-0.895,2-2V6C22,4.895,21.105,4,20,4z M20,8.236l-8,4.882 L4,8.236V6h16V8.236z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tEmail this Page\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-whatsapp has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/api.whatsapp.com\/send?text=Incorrect%20Power%20BI%20Report%20Data%20After%20Refresh%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2023%2F02%2F04%2Fincorrect-power-bi-report-data-after-refresh%2F\" aria-label=\"Share on WhatsApp\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M 12.011719 2 C 6.5057187 2 2.0234844 6.478375 2.0214844 11.984375 C 2.0204844 13.744375 2.4814687 15.462563 3.3554688 16.976562 L 2 22 L 7.2324219 20.763672 C 8.6914219 21.559672 10.333859 21.977516 12.005859 21.978516 L 12.009766 21.978516 C 17.514766 21.978516 21.995047 17.499141 21.998047 11.994141 C 22.000047 9.3251406 20.962172 6.8157344 19.076172 4.9277344 C 17.190172 3.0407344 14.683719 2.001 12.011719 2 z M 12.009766 4 C 14.145766 4.001 16.153109 4.8337969 17.662109 6.3417969 C 19.171109 7.8517969 20.000047 9.8581875 19.998047 11.992188 C 19.996047 16.396187 16.413812 19.978516 12.007812 19.978516 C 10.674812 19.977516 9.3544062 19.642812 8.1914062 19.007812 L 7.5175781 18.640625 L 6.7734375 18.816406 L 4.8046875 19.28125 L 5.2851562 17.496094 L 5.5019531 16.695312 L 5.0878906 15.976562 C 4.3898906 14.768562 4.0204844 13.387375 4.0214844 11.984375 C 4.0234844 7.582375 7.6067656 4 12.009766 4 z M 8.4765625 7.375 C 8.3095625 7.375 8.0395469 7.4375 7.8105469 7.6875 C 7.5815469 7.9365 6.9355469 8.5395781 6.9355469 9.7675781 C 6.9355469 10.995578 7.8300781 12.182609 7.9550781 12.349609 C 8.0790781 12.515609 9.68175 15.115234 12.21875 16.115234 C 14.32675 16.946234 14.754891 16.782234 15.212891 16.740234 C 15.670891 16.699234 16.690438 16.137687 16.898438 15.554688 C 17.106437 14.971687 17.106922 14.470187 17.044922 14.367188 C 16.982922 14.263188 16.816406 14.201172 16.566406 14.076172 C 16.317406 13.951172 15.090328 13.348625 14.861328 13.265625 C 14.632328 13.182625 14.464828 13.140625 14.298828 13.390625 C 14.132828 13.640625 13.655766 14.201187 13.509766 14.367188 C 13.363766 14.534188 13.21875 14.556641 12.96875 14.431641 C 12.71875 14.305641 11.914938 14.041406 10.960938 13.191406 C 10.218937 12.530406 9.7182656 11.714844 9.5722656 11.464844 C 9.4272656 11.215844 9.5585938 11.079078 9.6835938 10.955078 C 9.7955938 10.843078 9.9316406 10.663578 10.056641 10.517578 C 10.180641 10.371578 10.223641 10.267562 10.306641 10.101562 C 10.389641 9.9355625 10.347156 9.7890625 10.285156 9.6640625 C 10.223156 9.5390625 9.737625 8.3065 9.515625 7.8125 C 9.328625 7.3975 9.131125 7.3878594 8.953125 7.3808594 C 8.808125 7.3748594 8.6425625 7.375 8.4765625 7.375 z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on WhatsApp\t\t<\/span>\n\t<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">You just spent a lot of time designing your report and now it&#8217;s time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to the report. But wait, these numbers are incorrect and not at all what you see in Power BI Desktop. How could this be? It may be because of <strong>different locale settings<\/strong> between Power BI Desktop and the Power BI Service. Let me explain with an example. [<a href=\"#solution\"><em>Click here if you want to jump directly to the solution<\/em><\/a>]<\/p>\n\n\n\n<hr class=\"wp-block-separator alignwide has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">The Problem<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To illustrate the issue I created a .csv File with the following content:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-2.png\" alt=\"\" class=\"wp-image-233\" width=\"417\" height=\"98\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-2.png 556w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-2-300x70.png 300w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><figcaption class=\"wp-element-caption\">CSV Example Data<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The first column indicates which decimal separator was used to write the number &#8220;0.05&#8221;, the value of the number is then written in the &#8220;Number&#8221; column and in the column &#8220;String&#8221; the literal representation of the number in the file is provided. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When loading this .csv file locally in Power BI Desktop, everything works as expected.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIDesktopLoad-1024x397.png\" alt=\"\" class=\"wp-image-234\" width=\"768\" height=\"298\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIDesktopLoad-1024x397.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIDesktopLoad-300x116.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIDesktopLoad-768x298.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIDesktopLoad.png 1186w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><figcaption class=\"wp-element-caption\">Data in Power BI Desktop <\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now I publish the report to the Power BI Service and refresh the data from the .csv file. After the refresh, the data in the Power BI Service is displayed incorrectly. We expected the same value of 0.05 as indicated in the column &#8220;String&#8221; but instead, we get the number 5 formatted with two zeros after the decimal separator. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIService.png\" alt=\"\" class=\"wp-image-235\" width=\"623\" height=\"266\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIService.png 830w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIService-300x128.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/PowerBIService-768x328.png 768w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><figcaption class=\"wp-element-caption\">Data in Power BI Service<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This is not just a formatting problem! The data in the Power BI Service is way off, in this example by a factor of 100. So what happened exactly and how can you fix it?<\/p>\n\n\n\n<hr class=\"wp-block-separator alignwide has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">The Context<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the simple example, it is easy to spot: Somehow Power BI changed something about the interpretation of the decimal separator. But why does everything work locally and break in the Service? The answer is a different locale setting in Power BI Desktop and Service.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">&#8211; Power BI Locale Settings<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Check the language setting in Power BI located at &#8220;File &gt; Options and settings &gt; Options &gt; Current File &gt; Regional Settings&#8221; <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image.png\" alt=\"\" class=\"wp-image-230\" width=\"697\" height=\"160\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image.png 929w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-300x69.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-768x176.png 768w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><figcaption class=\"wp-element-caption\">Power BI Desktop &#8211; Current File &#8211; Regional Settings<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This setting influences how your data is interpreted. After creating a new report, the locale is initially configured and is influenced by the settings on your current machine. <\/p>\n\n\n\n<h6 class=\"wp-block-heading\">&#8211;  Power BI Service<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Depending on which language you selected in the Power BI Service in &#8220;Settings &gt; Language&#8221;, data is formatted differently to match the usual format of your language. But this only changes how data is displayed, not the actual data itself. Your Power BI Tenant has a physical location and you can check where your Power BI Data is stored currently. Check this in the Power BI Service and click on &#8220;Help &amp; Support &gt; About Power BI&#8221;. In the subsequent window, your data location is displayed. <\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-f56f613f wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/AboutPowerBI-1-1024x506.png\" alt=\"\" class=\"wp-image-241\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/AboutPowerBI-1-1024x506.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/AboutPowerBI-1-300x148.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/AboutPowerBI-1-768x379.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/AboutPowerBI-1.png 1470w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Power BI Service Information<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/SettingAbout.png\" alt=\"\" class=\"wp-image-240\" width=\"437\" height=\"415\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/SettingAbout.png 874w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/SettingAbout-300x285.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/SettingAbout-768x729.png 768w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><figcaption class=\"wp-element-caption\">Help &amp; Support &gt; About Power BI<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">At this point you might ask:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<h5 class=\"wp-block-heading\">So if i change the locale to something similar as the location of my power bi tenant everything works, right?<\/h5>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Changing your local setting can help Power BI Desktop to behave identically to the Power BI Service, provided you find the correct locale, and this is something you should absolutely do. After changing the locale and refreshing the data in Power BI Desktop, you can expect to have the same incorrect data as in the Service. Still wrong, but at least consistently wrong:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-3-1024x381.png\" alt=\"\" class=\"wp-image-236\" width=\"768\" height=\"286\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-3-1024x381.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-3-300x112.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-3-768x286.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-3.png 1077w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><figcaption class=\"wp-element-caption\">Power BI Desktop after locale settings change<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This means the actual problem is a mismatch between the source data and the way Power BI tries to interpret the data when loading it into the report. How the data is provided is dependent on the source system and often this can&#8217;t be changed. Here is a way to fix it directly when loading the data in Power BI:<\/p>\n\n\n\n<hr class=\"wp-block-separator alignwide has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"has-text-align-left wp-block-heading\" id=\"solution\">The Solution<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In Power BI Desktop:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to the Power Query Editor<\/li>\n\n\n\n<li>Right click on your column and Select &#8220;Change Type > Using Locale&#8230;&#8221;<\/li>\n\n\n\n<li>Provide the data type and the matching locale setting to convert your data reliably<\/li>\n\n\n\n<li>Quit Power Query Editor and refresh the data<\/li>\n\n\n\n<li>Ensure the data was loaded correctly in the local report<\/li>\n\n\n\n<li>Upload the report to Power BI Service<\/li>\n\n\n\n<li>Refresh data in Power BI Service<\/li>\n\n\n\n<li>Ensure the data was loaded correctly in the online report<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-f56f613f wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/ChangeTypeUsingLocale-1024x670.png\" alt=\"\" class=\"wp-image-238\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/ChangeTypeUsingLocale-1024x670.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/ChangeTypeUsingLocale-300x196.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/ChangeTypeUsingLocale-768x502.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/ChangeTypeUsingLocale.png 1352w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Step 2: Change type using locale<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"646\" height=\"497\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-5.png\" alt=\"\" class=\"wp-image-239\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-5.png 646w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/image-5-300x231.png 300w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><figcaption class=\"wp-element-caption\">Step 3: Data type and locale<\/figcaption><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>You just spent a lot of time designing your report and now it&#8217;s time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to the report. But wait, these numbers are incorrect and not at all what you see in Power BI Desktop. How could this be? It may be because of different locale settings between Power BI Desktop and the Power BI Service.<\/p>\n","protected":false},"author":3,"featured_media":257,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7],"tags":[6,24],"class_list":["post-227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-engineering","tag-power-bi","tag-power-query"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Incorrect Power BI Report Data After Refresh - Syntera<\/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.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Incorrect Power BI Report Data After Refresh - Syntera\" \/>\n<meta property=\"og:description\" content=\"You just spent a lot of time designing your report and now it&#039;s time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to the report. But wait, these numbers are incorrect and not at all what you see in Power BI Desktop. How could this be? It may be because of different locale settings between Power BI Desktop and the Power BI Service.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/\" \/>\n<meta property=\"og:site_name\" content=\"Syntera\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-04T13:01:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-07T15:33:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2734\" \/>\n\t<meta property=\"og:image:height\" content=\"934\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dominic Schranz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dominic Schranz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/\",\"url\":\"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/\",\"name\":\"Incorrect Power BI Report Data After Refresh - Syntera\",\"isPartOf\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\"},\"datePublished\":\"2023-02-04T13:01:27+00:00\",\"dateModified\":\"2023-02-07T15:33:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.syntera.ch\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Incorrect Power BI Report Data After Refresh\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\",\"url\":\"https:\/\/www.syntera.ch\/blog\/\",\"name\":\"Syntera\",\"description\":\"translating data into business value.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d\",\"name\":\"Dominic Schranz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g\",\"caption\":\"Dominic Schranz\"},\"url\":\"https:\/\/www.syntera.ch\/blog\/author\/domi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Incorrect Power BI Report Data After Refresh - Syntera","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.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/","og_locale":"en_US","og_type":"article","og_title":"Incorrect Power BI Report Data After Refresh - Syntera","og_description":"You just spent a lot of time designing your report and now it's time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to the report. But wait, these numbers are incorrect and not at all what you see in Power BI Desktop. How could this be? It may be because of different locale settings between Power BI Desktop and the Power BI Service.","og_url":"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/","og_site_name":"Syntera","article_published_time":"2023-02-04T13:01:27+00:00","article_modified_time":"2023-02-07T15:33:47+00:00","og_image":[{"width":2734,"height":934,"url":"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2023\/02\/thumbnail.png","type":"image\/png"}],"author":"Dominic Schranz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dominic Schranz","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/","url":"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/","name":"Incorrect Power BI Report Data After Refresh - Syntera","isPartOf":{"@id":"https:\/\/www.syntera.ch\/blog\/#website"},"datePublished":"2023-02-04T13:01:27+00:00","dateModified":"2023-02-07T15:33:47+00:00","author":{"@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d"},"breadcrumb":{"@id":"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.syntera.ch\/blog\/2023\/02\/04\/incorrect-power-bi-report-data-after-refresh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.syntera.ch\/blog\/"},{"@type":"ListItem","position":2,"name":"Incorrect Power BI Report Data After Refresh"}]},{"@type":"WebSite","@id":"https:\/\/www.syntera.ch\/blog\/#website","url":"https:\/\/www.syntera.ch\/blog\/","name":"Syntera","description":"translating data into business value.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/e038d1dcebeca2193c5503f78783988d","name":"Dominic Schranz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bd3589b8a6ccc62e37c3cee8f8e06c73a4085816337ad7d6c154e30dc60cc4c1?s=96&d=mm&r=g","caption":"Dominic Schranz"},"url":"https:\/\/www.syntera.ch\/blog\/author\/domi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/comments?post=227"}],"version-history":[{"count":15,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":258,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/227\/revisions\/258"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media\/257"}],"wp:attachment":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/tags?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}