learn.microsoft.com
Open in
urlscan Pro
2a02:26f0:3100:19d::3544
Public Scan
Submitted URL: https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios
Effective URL: https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios
Submission: On June 03 via api from IN — Scanned from DE
Effective URL: https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios
Submission: On June 03 via api from IN — Scanned from DE
Form analysis 3 forms found in the DOM
Name: site-header-search-form-mobile — GET /en-us/search/
<form class="flex-grow-1" method="GET" role="search" id="ms--site-header-search-form-mobile" data-bi-name="site-header-search-form-mobile" name="site-header-search-form-mobile" aria-label="Search" action="/en-us/search/">
<div class="autocomplete display-block" data-bi-name="autocomplete"><!---->
<div class="field-body control ">
<input role="combobox" maxlength="100" aria-autocomplete="list" autocapitalize="off" autocomplete="off" autocorrect="off" spellcheck="false" id="site-header-search-autocomplete-input-mobile"
data-test-id="site-header-search-autocomplete-input-mobile" class="autocomplete-input input
width-full" type="search" name="terms" aria-expanded="false" aria-owns="ax-1-listbox" aria-controls="ax-1-listbox" aria-activedescendant="" aria-label="Search" aria-describedby="ms--site-header-search-autocomplete-input-mobile-description"
placeholder="Search" data-bi-name="site-header-search-autocomplete-input-mobile" pattern=".*">
<span aria-hidden="true" class="autocomplete-loader loader has-text-primary " hidden=""></span>
<span hidden="" id="ms--site-header-search-autocomplete-input-mobile-description"> Suggestions will filter as you type </span>
</div>
<ul role="listbox" id="ax-1-listbox" data-test-id="site-header-search-autocomplete-input-mobile-listbox" class="autocomplete-suggestions is-vertically-scrollable padding-xxs " aria-label="Suggestions" hidden="">
</ul>
<!---->
</div>
<!-- mobile safari will not dispatch submit event unless there's a submit button that is not display:none -->
<button type="submit" class="visually-hidden" tabindex="-1" aria-hidden="true"></button>
<input name="category" hidden="" value="">
</form>Name: site-header-search-form — GET /en-us/search/
<form class="flex-grow-1" method="GET" role="search" id="ms--site-header-search-form" data-bi-name="site-header-search-form" name="site-header-search-form" aria-label="Search" action="/en-us/search/">
<div class="autocomplete display-block" data-bi-name="autocomplete"><!---->
<div class="field-body control ">
<input role="combobox" maxlength="100" aria-autocomplete="list" autocapitalize="off" autocomplete="off" autocorrect="off" spellcheck="false" id="site-header-search-autocomplete-input" data-test-id="site-header-search-autocomplete-input" class="autocomplete-input input input-sm
width-full" type="search" name="terms" aria-expanded="false" aria-owns="ax-0-listbox" aria-controls="ax-0-listbox" aria-activedescendant="" aria-label="Search" aria-describedby="ms--site-header-search-autocomplete-input-description"
placeholder="Search" data-bi-name="site-header-search-autocomplete-input" pattern=".*">
<span aria-hidden="true" class="autocomplete-loader loader has-text-primary " hidden=""></span>
<span hidden="" id="ms--site-header-search-autocomplete-input-description"> Suggestions will filter as you type </span>
</div>
<ul role="listbox" id="ax-0-listbox" data-test-id="site-header-search-autocomplete-input-listbox" class="autocomplete-suggestions is-vertically-scrollable padding-xxs " aria-label="Suggestions" hidden="">
</ul>
<!---->
</div>
<!-- mobile safari will not dispatch submit event unless there's a submit button that is not display:none -->
<button type="submit" class="visually-hidden" tabindex="-1" aria-hidden="true"></button>
<input name="category" hidden="" value="">
</form>javascript:
<form action="javascript:" role="search" aria-label="Search" class="margin-bottom-xxs"><label class="visually-hidden" for="ax-2">Search</label>
<div class="autocomplete display-block" data-bi-name="autocomplete"><!---->
<div class="field-body control has-icons-left">
<input role="combobox" maxlength="100" aria-autocomplete="list" autocapitalize="off" autocomplete="off" autocorrect="off" spellcheck="false" id="ax-2" data-test-id="ax-2" class="autocomplete-input input input-sm
control has-icons-left
width-full" type="text" aria-expanded="false" aria-owns="ax-3-listbox" aria-controls="ax-3-listbox" aria-activedescendant="" aria-describedby="ms--ax-2-description" placeholder="Filter by title" pattern=".*">
<span aria-hidden="true" class="icon is-small is-left">
<span class="has-text-primary docon docon-filter-settings"></span>
</span>
<span aria-hidden="true" class="autocomplete-loader loader has-text-primary " hidden=""></span>
<span hidden="" id="ms--ax-2-description"> Suggestions will filter as you type </span>
</div>
<ul role="listbox" id="ax-3-listbox" data-test-id="ax-2-listbox" class="autocomplete-suggestions is-vertically-scrollable padding-xxs " aria-label="Suggestions" hidden="">
</ul>
<!---->
</div>
</form>Text Content
Skip to main content
We use optional cookies to improve your experience on our websites, such as
through social media connections, and to display personalized advertising based
on your online activity. If you reject optional cookies, only cookies necessary
to provide you the services will be used. You may change your selection by
clicking “Manage Cookies” at the bottom of the page. Privacy Statement
Third-Party Cookies
Accept Reject Manage cookies
TAKE THE CHALLENGE
May 21 – June 21, 2024
Grow your AI skills with the Microsoft Learn Challenge: Build Edition.
Register now
Dismiss alert
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security
updates, and technical support.
Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Learn
Suggestions will filter as you type
Sign in
* Profile
* Settings
Sign out
Learn
* Discover
* Documentation
In-depth articles on Microsoft developer tools and technologies
* Training
Personalized learning paths and courses
* Credentials
Globally recognized, industry-endorsed credentials
* Q&A
Technical questions and answers moderated by Microsoft
* Code Samples
Code sample library for Microsoft developer tools and technologies
* Assessments
Interactive, curated guidance and recommendations
* Shows
Thousands of hours of original programming from Microsoft experts
Featured assessment
It's your AI learning journey
Wherever you are in your AI journey, Microsoft Learn meets you where you are
and helps you deepen your skills.
* Product documentation
* ASP.NET
* Azure
* Dynamics 365
* Microsoft 365
* Microsoft Edge
* Microsoft Entra
* Microsoft Graph
* Microsoft Intune
* Microsoft Purview
* Microsoft Teams
* .NET
* Power Apps
* Power Automate
* Power BI
* Power Platform
* PowerShell
* SQL
* Sysinternals
* Visual Studio
* Windows
* Windows Server
View all products
Featured assessment
It's your AI learning journey
Wherever you are in your AI journey, Microsoft Learn meets you where you are
and helps you deepen your skills.
* Development languages
* C++
* C#
* DAX
* Java
* OData
* OpenAPI
* Power Query M
* VBA
Featured assessment
It's your AI learning journey
Wherever you are in your AI journey, Microsoft Learn meets you where you are
and helps you deepen your skills.
* Topics
* Artificial intelligence
* Compliance
* DevOps
* Platform engineering
* Security
Featured assessment
It's your AI learning journey
Wherever you are in your AI journey, Microsoft Learn meets you where you are
and helps you deepen your skills.
Suggestions will filter as you type
Sign in
* Profile
* Settings
Sign out
Power BI
* Get started
* Power BI get started documentation
* What is Power BI?
* Basic concepts
* Learn Power BI
* Individual sign-up
* Work with data
* Connect to data documentation
* Transform, shape, and model data documentation
* Data refresh
* On-premises gateways
* DAX basics
* Create and manage relationships
* Create measures
* Create & share
* Create reports and dashboards documentation
* Collaborate, share, and integrate across products documentation
* Get Power BI samples
* Use report themes
* Add conditional table formatting
* Ways to share your work
* Organize work in the new workspaces
* Publish to web
* Admin & enterprise
* Admin documentation
* Enterprise documentation
* Purchase Power BI Pro licenses
* What is Power BI Premium?
* Row-level security (RLS)
* Licensing the Power BI service
* Developer
* Power BI developer documentation
* Embedded analytics documentation
* Visuals documentation
* Automation documentation
* Resources
* Products
* Power BI Service
* Power BI Desktop
* Power BI Report Server
* Power BI Report Builder
* Power BI Mobile
* Power BI training
* Learn Power BI
* Become a Power BI data analyst
* Support
* Community
* Give Feedback
* Release plan
* Team blog
* More
* Get started
* Power BI get started documentation
* What is Power BI?
* Basic concepts
* Learn Power BI
* Individual sign-up
* Work with data
* Connect to data documentation
* Transform, shape, and model data documentation
* Data refresh
* On-premises gateways
* DAX basics
* Create and manage relationships
* Create measures
* Create & share
* Create reports and dashboards documentation
* Collaborate, share, and integrate across products documentation
* Get Power BI samples
* Use report themes
* Add conditional table formatting
* Ways to share your work
* Organize work in the new workspaces
* Publish to web
* Admin & enterprise
* Admin documentation
* Enterprise documentation
* Purchase Power BI Pro licenses
* What is Power BI Premium?
* Row-level security (RLS)
* Licensing the Power BI service
* Developer
* Power BI developer documentation
* Embedded analytics documentation
* Visuals documentation
* Automation documentation
* Resources
* Products
* Power BI Service
* Power BI Desktop
* Power BI Report Server
* Power BI Report Builder
* Power BI Mobile
* Power BI training
* Learn Power BI
* Become a Power BI data analyst
* Support
* Community
* Give Feedback
* Release plan
* Team blog
Buy now Open Power BI
Table of contents Exit focus mode
Search
Suggestions will filter as you type
* Connect to data in Power BI
* Overview
* Data sources in Power BI
* What is an on-premises data gateway?
* OneLake data hub
* Semantic model details page
* Datamart details page
* Power BI for Azure users
* Quickstarts
* Connect to data in Power BI Desktop
* Tutorials
* Shape and combine multiple data sources
* Import and analyze webpage data
* Analyze sales data from Excel and an OData feed
* Implement row-level security in an Analysis Services tabular model
* Connect to a GitHub sample
* Use Cognitive Services
* Build a machine learning model
* Refresh data from SQL Server
* Automate template app configuration
* Concepts
* Power BI data sources
* New name for Power BI datasets
* Semantic models in the Power BI service
* Semantic model modes in the Power BI service
* Power BI data source prerequisites
* Using enhanced semantic model metadata in Power BI Desktop
* Work with multidimensional models in Power BI
* About using DirectQuery in Power BI
* Live connection and DirectQuery comparison
* How-to guides
* Connect to data sources in Power BI Desktop
* Connect to cloud data sources in the Power BI service
* Create and share cloud data sources in the Power BI service
* Connect to data
* Get data from files
* Get data from shared semantic models
* Get data from databases
* Refresh data
* Template apps
* Connect to services
* Gateways
* Troubleshoot
* Troubleshoot opening Power BI Desktop
* Troubleshoot refresh scenarios
* Troubleshoot tile errors
* Troubleshoot an unsupported data source for refresh
* Troubleshoot scheduled refresh for Azure SQL Databases
* Troubleshoot analyze in Excel
* Error: We couldn't find any data in your Excel workbook
* Troubleshoot importing Access and Excel .xls files
* Troubleshoot developing DirectQuery models
* Troubleshooting Nested Values
* Reference
Download PDF
1. Learn
2. Power Platform
3. Power BI
1. Learn
2. Power Platform
3. Power BI
Read in English Save
* Add to Collections
* Add to Plan
Table of contents Read in English Add to Collections Add to Plan Edit
--------------------------------------------------------------------------------
SHARE VIA
Facebook x.com LinkedIn Email
--------------------------------------------------------------------------------
Print
Table of contents
TROUBLESHOOT REFRESH SCENARIOS
* Article
* 04/16/2024
* 10 contributors
Feedback
IN THIS ARTICLE
1. Email notifications
2. Refresh using Web connector doesn't work properly
3. Unsupported data source for refresh
4. Dashboard doesn't reflect changes after refresh
5. GatewayNotReachable when setting credentials
6. Processing Error: The following system error occurred: Type Mismatch
7. Tile refresh errors
8. Refresh fails when updating data from sources that use Microsoft Entra ID
OAuth
9. Uncompressed data limits for refresh
10. Scheduled refresh time-out
11. Scheduled refresh disabled
12. Access to the resource is forbidden
13. Data refresh failure because of password change or expired credentials
14. Refresh a column of the ANY type that contains TRUE or FALSE results in
unexpected values
15. Resolve the error: Container exited unexpectedly with code 0x0000DEAD
16. Refresh operation throttled by Power BI Premium
17. Dataflows or datamart failures in Premium workspaces
18. There was a problem refreshing the dataflow, the gateway version you are
using is not supported
19. Related content
Show 15 more
This article describes different scenarios you might encounter when refreshing
data within the Power BI service.
Note
If you encounter a scenario that's not listed in this article, and if it's
causing issues, you can ask for further assistance on the community site, or you
can create a support ticket.
You should always ensure that basic requirements for refresh are met and
verified:
* Verify the gateway version is up to date.
* Verify the report has a gateway selected. If there's no gateway selected, the
data source might have changed or might be missing.
After you confirm the requirements are met, take a look through the following
sections for more troubleshooting.
EMAIL NOTIFICATIONS
If you're coming to this article from an email notification, and you no longer
want to receive emails about refresh issues, contact your Power BI admin. Ask
them to remove your email, or an email list you're subscribed to, from the
appropriate semantic models in Power BI. An admin uses the following area in the
Power BI admin portal.
REFRESH USING WEB CONNECTOR DOESN'T WORK PROPERLY
If you have a Web connector script that's using the Web.Page function, and
you've updated your semantic model or report after November 18, 2016, you must
use a gateway for refresh to work properly.
UNSUPPORTED DATA SOURCE FOR REFRESH
When you configure a semantic model, you might get an error indicating the
semantic model uses an unsupported data source for refresh. For details, see
Troubleshooting unsupported data source for refresh.
DASHBOARD DOESN'T REFLECT CHANGES AFTER REFRESH
Wait 10-15 minutes for a refresh to be reflected in the dashboard tiles. If it
still doesn't show up, repin the visualization to the dashboard.
GATEWAYNOTREACHABLE WHEN SETTING CREDENTIALS
You might encounter a GatewayNotReachable error when you try to set credentials
for a data source, which can be the result of an outdated gateway. Install the
latest gateway and try again.
PROCESSING ERROR: THE FOLLOWING SYSTEM ERROR OCCURRED: TYPE MISMATCH
This error could be an issue with your M script within your Power BI Desktop
file or Excel workbook. It can also be due to an out-of-date Power BI Desktop
version.
TILE REFRESH ERRORS
For a list of errors you might encounter with dashboard tiles, and explanations,
see Troubleshooting tile errors.
REFRESH FAILS WHEN UPDATING DATA FROM SOURCES THAT USE MICROSOFT ENTRA ID OAUTH
The Microsoft Entra ID (Microsoft Entra ID) OAuth token, used by many different
data sources, expires in approximately one hour. Sometimes that token expires
before the data has finished loading, since the Power BI service waits for up to
two hours when loading data. In that situation, the data loading process can
fail with a credentials error.
Data sources that use Microsoft Entra ID OAuth include Microsoft Dynamics CRM
Online, SharePoint Online (SPO), and others. If you’re connecting to such data
sources, and get a credentials failure when loading data takes more than an
hour, OAuth might be the reason.
Microsoft is investigating a solution that allows the data loading process to
refresh the token and continue. However, if your Dynamics CRM Online or
SharePoint Online instance is so large that it runs over the two-hour data-load
threshold, the Power BI service might report a data load time-out. This data
load time-out also applies to other Microsoft Entra ID OAuth data sources.
For refresh to work properly when connecting to a SharePoint Online data source
by using Microsoft Entra ID OAuth, you must use the same account that you use to
sign in to the Power BI service.
If you want to connect to a data source from Power BI service by using OAuth2,
the data source must be in the same tenant as the Power BI service. Currently,
multitenant connection scenarios aren’t supported with OAuth2.
UNCOMPRESSED DATA LIMITS FOR REFRESH
The maximum size for semantic models imported into the Power BI service is 1 GB.
These semantic models are heavily compressed to ensure high performance. In
addition, in shared capacity, the service places a limit of 10 GB on the amount
of uncompressed data that is processed during refresh. This limit accounts for
the compression, and therefore is higher than the 1-GB maximum semantic model
size. Semantic models in Power BI Premium aren't subject to these limits. If
refresh in the Power BI service fails for this reason, reduce the amount of data
being imported to Power BI and try again.
SCHEDULED REFRESH TIME-OUT
Scheduled refresh for imported semantic models time out after two hours. This
time-out is increased to five hours for semantic models in Premium workspaces.
If you encounter this limit, consider reducing the size or complexity of your
semantic model, or consider refactoring the large semantic model into multiple
smaller semantic models.
SCHEDULED REFRESH DISABLED
If a scheduled refresh fails four times in a row, Power BI disables the refresh.
Address the underlying problem, and then re-enable the scheduled refresh.
However, if the semantic model resides in a workspace under Embedded capacity,
and that capacity is switched off, the first attempt at refresh will fail (since
the capacity is switched off), and in this circumstance its scheduled refresh is
immediately disabled.
ACCESS TO THE RESOURCE IS FORBIDDEN
This error can occur because of expired cached credentials. Clear your internet
browser cache, then sign in to Power BI and go to
https://app.powerbi.com?alwaysPromptForContentProviderCreds=true to force an
update of your credentials.
DATA REFRESH FAILURE BECAUSE OF PASSWORD CHANGE OR EXPIRED CREDENTIALS
Data refresh can also fail due to expired cached credentials. Clear your
internet browser cache, then sign in to Power BI and go to
https://app.powerbi.com?alwaysPromptForContentProviderCreds=true, which forces
an update of your credentials.
REFRESH A COLUMN OF THE ANY TYPE THAT CONTAINS TRUE OR FALSE RESULTS IN
UNEXPECTED VALUES
When you create a report in Power BI Desktop that has an ANY data type column
containing TRUE or FALSE values, the values of that column can differ between
Power BI Desktop and the Power BI service after a refresh. In Power BI Desktop,
the underlying engine converts the boolean values to strings, retaining TRUE or
FALSE values. In the Power BI service, the underlying engine converts the values
to objects, and then converts the values to -1 or 0.
Visuals created in Power BI Desktop by using such columns might behave or appear
as designed prior to a refresh event, but might change (due to TRUE/FALSE being
converted to -1/0) after the refresh event.
RESOLVE THE ERROR: CONTAINER EXITED UNEXPECTEDLY WITH CODE 0X0000DEAD
If you get the Container exited unexpectedly with code 0x0000DEAD error, try to
disable the scheduled refresh and republish the semantic model.
REFRESH OPERATION THROTTLED BY POWER BI PREMIUM
A Premium capacity might throttle data refresh operations when too many semantic
models are being processed concurrently. Throttling can occur in Power BI
Premium capacities. When a refresh operation is canceled, the following error
messages are logged into the refresh history:
You've exceeded the capacity limit for semantic model refreshes. Try again when
fewer semantic models are being processed.
If the error occurs frequently, use the schedule view to determine whether the
scheduled refresh events are properly spaced. To understand the maximum number
of concurrent refreshes allowed per SKU, review the Capacities and SKUs table.
To resolve this error, you can modify your refresh schedule to perform the
refresh operation when fewer semantic models are being processed. You can also
increase the time between refresh operations for all semantic models in your
refresh schedule on the affected Premium capacity. You can retry the operation
if you're using custom XMLA operations.
Capacity level limit exceeded.
This error indicates you have too many semantic models running refresh at the
same time, based on the capacity your organization has purchased. You can retry
the refresh operation, or reschedule the refresh time to address this error.
Node level limit exceeded.
This error indicates a system error in Power BI Premium based on semantic models
residing on a given physical node. You can retry the refresh operation, or
reschedule the refresh time to address this error.
DATAFLOWS OR DATAMART FAILURES IN PREMIUM WORKSPACES
Some connectors aren't supported for dataflows and datamarts in Premium
workspaces. When using an unsupported connector, you may receive the following
error: Expression.Error: The import "<"connector name">" matches no exports. Did
you miss a module reference?
The following connectors aren't supported for dataflows and datamarts in Premium
workspaces:
* Linkar
* Actian
* AmazonAthena
* AmazonOpenSearchService
* BIConnector
* DataVirtuality
* DenodoForPowerBI
* Exasol
* Foundry
* Indexima
* IRIS
* JethroODBC
* Kyligence
* MariaDB
* MarkLogicODBC
* OpenSearchProject
* QubolePresto
* SingleStoreODBC
* StarburstPresto
* TibcoTdv
The use of the previous list of connectors with dataflows or datamarts is only
supported workspaces that are not Premium.
THERE WAS A PROBLEM REFRESHING THE DATAFLOW, THE GATEWAY VERSION YOU ARE USING
IS NOT SUPPORTED
This error occurs if the version of the on-premises data gateway being used to
refresh your dataflow (Gen1 or Gen2) is out of support. Currently Microsoft
supports only the last six versions of the on-premises data gateway. Update your
gateway to the latest version, or a supported version to resolve this issue. Use
the update an on-premises data gateway article for guidance on updating
gateways.
RELATED CONTENT
* Data refresh in Power BI
* Troubleshoot the On-premises data gateway
* Troubleshooting the Power BI Gateway - Personal
More questions? Try asking the Microsoft Power BI Community.
--------------------------------------------------------------------------------
FEEDBACK
Was this page helpful?
Yes No
Provide product feedback |
Ask the community
FEEDBACK
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the
feedback mechanism for content and replacing it with a new feedback system. For
more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for
This product This page
View all page feedback
--------------------------------------------------------------------------------
ADDITIONAL RESOURCES
--------------------------------------------------------------------------------
Training
Module
Manage semantic models in Power BI - Training
With Microsoft Power BI, you can use a single semantic model to build many
reports. Reduce your administrative overhead even more with scheduled semantic
model refreshes and resolving connectivity errors.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical
requirements for modeling, visualizing, and analyzing data with Microsoft Power
BI.
--------------------------------------------------------------------------------
Events
Take the challenge
May 21, 6 PM - Jun 21, 6 PM
Grow your AI skills with the Microsoft Learn Challenge: Build Edition —
Microsoft Fabric.
Register now
English (United States)
California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
Theme
* Light
* Dark
* High contrast
* Manage cookies
* Previous Versions
* Blog
* Contribute
* Privacy
* Terms of Use
* Trademarks
* © Microsoft 2024
ADDITIONAL RESOURCES
--------------------------------------------------------------------------------
Events
Take the challenge
May 21, 6 PM - Jun 21, 6 PM
Grow your AI skills with the Microsoft Learn Challenge: Build Edition —
Microsoft Fabric.
Register now
--------------------------------------------------------------------------------
Training
Module
Manage semantic models in Power BI - Training
With Microsoft Power BI, you can use a single semantic model to build many
reports. Reduce your administrative overhead even more with scheduled semantic
model refreshes and resolving connectivity errors.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical
requirements for modeling, visualizing, and analyzing data with Microsoft Power
BI.
IN THIS ARTICLE
English (United States)
California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
Theme
* Light
* Dark
* High contrast
* Manage cookies
* Previous Versions
* Blog
* Contribute
* Privacy
* Terms of Use
* Trademarks
* © Microsoft 2024