How to: Fix Power Bi Error the Provider is Not Registered

0
39
How to: Fix Power Bi Error the Provider is Not Registered

Here we can see, “How to: Fix Power Bi Error the Provider is Not Registered”

You could occasionally run into a not registered problem while attempting to connect to a 32-bit access database from a Power BI-64bit Desktop. Depending on the user, a variety of messages may accompany the mistake. According to reports from users in the Power Bi community forum, the provider is not registered Power Bi problem can also happen when service is refreshed.

I built a report using PBI Desktop – the source is an Excel file on a public website (not OneDrive).  When I publish it and then try to use the Power BI site to refresh the dataset, I get this error:
Data source errorExcel Workbook: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required to connect to read this type of file

To fix the Power Bi issue, adhere to the steps in this article. Power Bi desktop and service problems have not been reported to the provider.

Also See:  Power Bi Error in Loading a Previous Table: Fix It With Our Steps

How to fix Power Bi error the provider is not registered

1. Install the 64-bit version of the Microsoft Access Database Engine

    1. Follow these instructions if the error particularly mentions problems with the Microsoft Access Database Engine 2010 and requests that you install the 64-bit version of the program.
    2. Visit the page for the Redistributable Microsoft Access Database Engine 2010 package.
    3. Click the Download button after choosing your language.
    4. Install the program on the computer that has Power Bi installed.
    5. Try to connect to Access DB from the Power BI desktop after the program has been installed. Verify to see if the error has been fixed after installing the 64-bit version of the program.

2. Delete and recreate Shortcut

    1. Try removing the Power Bi desktop shortcut.
    2. Now from the Start screen, create a new Desktop shortcut.
    3. Or you could just attempt to launch the Power Bi app from the start screen.
    4. If Power Bi fails to build cached directories inside the temporary directory, this problem could manifest.

3. Uninstall and Reinstall Power Bi Dekstop

    1. If the problem continues, you should try uninstalling Power Bi from your computer and installing it again.
    2. To launch Run, press Windows Key + R.
    3. To launch the Control Panel, enter control and press OK.
    4. Programs > Programs & Features should be selected.
    5. Select the Power Bi app and remove it.
    6. Visit the Power Bi download page right away to get the most recent version.
    7. Install the app and see whether the Power Bi not registered problem is fixed.

4. Other Solutions to Try

    1. Power Bi does not support ApiKeyName. As a result, you might wish to switch to basic authentication and try refreshing again if you’re trying to utilize ApiKeyname with the Power Bi service.
    2. Ensure you are using an.xlsx or.xlsm file type when checking your Excel file format. Additionally, confirm that the file size is less than 1 GB. Make careful to alter the file format and republish the file if it is not in the file mentioned above type.

Conclusion

I hope you found this guide useful. If you’ve got any questions or comments, don’t hesitate to use the shape below.

User Questions

1. Why doesn’t power bi function?

Security-related issues, such as instances where firewalls or antivirus software may block the pipes or reroute traffic to a particular port, are the most frequent causes of such interference. That problem might be fixed by opening Power BI Desktop with administrator privileges.

2. How can I repair a damaged Power BI file?

    1. Instead of double-clicking the location of the infected pbix file, open Power BI Desktop.
    2. Select the corrupted pbix file by selecting File > Open > File.
    3. A yellow ribbon with the words “open in auto-recovery mode.” will be visible. When you click it, the file will open in the previous version from before it became corrupted.

3. How can I run Power BI with administrator privileges?

The simplest method is to right-click on the desktop shortcut for Power BI Desktop, select Properties, then Compatibility, and then check the box next to “Run this software as an administrator.” Every time you open it, a prompt appears, but at least you can.

Also See:  How to: Fix This File Does Not Have a Program Associated With It

4. Microsoft.ACE.OLEDB.12.0 not registered – but it is! : r/SQL

Microsoft.ACE.OLEDB.12.0 not registered – but it is! from SQL

5. Connection to data source lost after Import from PowerPivot to …

Connection to data source lost after Import from PowerPivot to Power Bi from PowerBI