Why won't Power BI refresh dataset?

January 2023 · 4 minute read
power bi how to refresh

XINSTALL BY CLICKING THE DOWNLOAD FILE

To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:
  • Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  • Click Start Scan to find Windows issues that could be causing PC problems.
  • Click Repair All to fix issues affecting your computer's security and performance

    • Power BI users often need to refresh data to ensure their visualizations and charts are based on recent data. Users can select a Refresh Now option to refresh data. However, some Power BI users might encounter refresh errors when they try to update data.

    Learn how to fix this by following the instructions below.

    What to do if scheduled refresh fails in Power BI?

    1. Update Power BI Desktop

  • If a “Processing error” message pops up, users might need to update their Power BI Desktop versions. Press the Windows key + X hotkey.
  • Select Run on the menu that opens.
  • Input ‘appwiz.cpl’ in Run and click OK to open the window in the snapshot directly below.The uninstaller Power BI won't refresh
  • Then select Power BI Desktop, and click the Uninstall option.
  • Press the Yes button to confirm.
  • Restart Windows after uninstalling Power BI Desktop.
  • Next, click Advanced Download Options on the Power BI Desktop page.Power BI Desktop download page Power BI won't refresh
  • Click the Download button.
  • Select the .PBIDesktop.msi (32-bit installer) or PBIDesktop_x64.msi (64-bit installer) option, and click the Next button.
  • Thereafter, open the Power BI Desktop installer to install the latest version of the software.

    • 2. Reduce the Amount of Data Imported

    Power BI data refresh errors can arise when users try to import too much data. Note that the maximum size for imported data sets within the Power BI service is 1 GB. So, reduce the dataset size to import if it eclipses the 1 GB mark.

    3. Clear Internet Browser Cache

  • An “Access to the resource is forbidden” data refresh error might arise when cached credentials have expired. Users can clear a browser cache by logging in to the Power BI service.
  • Then open this link. That link will update a user’s credentials.

    • If that doesn’t help, you can always try using a different browser.

    Opera Browser is a privacy-based browser built on Chromium engine, so it’s quite similar to Chrome in terms of functionality.

    This browser has some unique features such as tracking and phishing protection. For extra security, there’s a built-in VPN and malware scanner. It’s a considerably lighter package than Chrome and using add-ons like the VPN and built-in ad-blocker offers a quicker and more responsive internet experience, as well as battery savings.

    These items, together with streamlined shortcuts and a variety of other features, can help you navigate the internet quicker. In terms of performance, Opera also has a unique Turbo option that may be used when your internet connection is really sluggish.

    If you haven’t already, be sure to try out Opera Browser.

    ⇒ Get Opera Browser

    4. Install the Latest Gateway

  • “GatewayNotReachable” data refresh errors can be due to antiquated gateways. To fix the “GatewayNotReachable” error, try installing the latest gateway by clicking the Download Gateway button on the Power BI gateway page.
  • Open the gateway’s installer.The gateway installer Power BI won't refresh
  • Click the Next button.
  • Select the On-premises data gateway (recommended) option, and click the Next button.
  • Click the Next button again.
  • Then click the … button to choose an installation path for the gateway.The Install to box Power BI won't refresh
  • Press the Install button.
  • After that, users will need to enter an email address to utilize with the gateway. Enter an email address for an Office 365 organization account in the text box.
  • Then press the Sign in button.
  • Thereafter, users will need to register a new gateway.

    • Those troubleshooting tips can potentially fix numerous Power BI refresh errors. For further fixes, users can also click the Create Support Ticket button on Power BI’s Support page to send a support ticket.

    ncG1vNJzZmivmaOxsMPSq5ypp6Kpe6S7zGinqK%2BVp3qjtYywpqesXaeyp77ErJ9o