Forum Discussion

ericjo's avatar
ericjo
Helper III
1 year ago
Solved

Power BI Error

I'm working within a VPN that doesn't allow internet access. I've requested and received approval from the security team for internet access for the required IP address. Until recently, it was worki...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi ericjo 

    Since this seems to involve a combination of connection, authentication, and missing component issues, here are steps you can take together with your IT team for troubleshooting:

    1. VPN and Network Configuration
      Even with security team approval, Power BI Desktop requires access to several domains over port 443 (HTTPS):
      *.powerbi.com, *.analysis.windows.net, *.microsoftonline.com, *.msftauth.net, login.microsoftonline.com
      Make sure these are allowed both in the firewall and DNS resolution. It's not enough to approve a single IP. Tools like Fiddler or Power BI Diagnostics can help identify blocked endpoints.

    2. TLS and System Requirements
      Make sure TLS 1.2 is enabled, Windows is fully updated, and you're using a supported version of Power BI Desktop. Outdated environments may block secure communication with Microsoft services.

    3. OLEDB Provider Not Registered
      The error 'microsoft.powerbi.oledb' is not registered usually means the provider is missing or failed to register. Try:

    • Reinstalling Power BI Desktop (preferably from the Microsoft Store)

    • Running it once as administrator to allow component registration

    • If needed, manually register the DLL (if you locate it) using regsvr32.

    1. Authentication Issues – WebView2
      Modern authentication in Power BI Desktop relies on WebView2 (Edge runtime). Ensure it's installed.
      If not, install it from the Microsoft site. You can also try launching Power BI with --disable-webview2 to test legacy mode.

    2. If VPN Restrictions Remain
      If no configuration works under VPN, consider authenticating and publishing from a non-VPN machine, then transferring the PBIX back into the VPN environment. Alternatively, use a Power BI Gateway from a machine with full access.

    If none of the above resolves the issue, I recommend opening a support ticket with Microsoft, especially if you're working in a controlled or enterprise environment.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi ericjo 

From the errors, there are two separate issues here  both likely related to network restrictions and local components:

1. Unable to access Power BI service / log in via VPN

  • Power BI Desktop and the service need access to certain endpoints. If your VPN blocks or restricts these, you’ll get “service connection terminated prematurely.”
  • Even if your security team previously allowed an IP range, Microsoft endpoints and IPs do change over time. They may need to review and re-approve based on the latest list.
  • Check that TLS inspection or SSL packet inspection is not breaking authentication.

2. OLEDB provider not registered

  • This means the local Microsoft Power BI OLEDB driver is missing or corrupted.
  • To fix:
    1. Install the latest version of Power BI Desktop from the Microsoft Store or official site.
    2. If already installed, run Repair from Apps & Features >> Power BI Desktop >> Modify >> Repair.
    3. If the issue persists, uninstall Power BI Desktop completely, reboot, and reinstall.

3. Combined steps to try

  1. Test Power BI Desktop outside of the VPN  if it works, it’s a network rule issue.
  2. Inside VPN, have IT check:
    • Latest Power BI endpoints are whitelisted (including login endpoints).
    • No outbound SSL inspection blocking auth.
  3. Repair/reinstall Power BI Desktop to restore missing OLEDB provider.