Facing a strange issue for some time. Power BI Desktop data laoding with the below eroor.
Failed to save modification to the server.Error returned. "The provider ‘Microsof.PowerBI.OleDb’ is not registered. The following system error occured. Class not registered’.
Issue is there to connect any data sources or even “enter Data” option as well.
Reinstalling solves the issue, but anyone is aware of permanent fix.
I am aware of a few possible permanent fixes for the issue “The provider ‘Microsof.PowerBI.OleDb’ is not registered. The following system error occured. Class not registered”.
1. Repair Power BI Desktop
Open the Control Panel and go to Programs > Programs and Features. Select Power BI Desktop and click on Change. Select Repair and click Next. Follow the on-screen instructions to complete the repair.
2. Register the Microsoft.PowerBI.OleDb provider
Open a command prompt as an administrator. Navigate to the directory where Power BI Desktop is installed. Run the following command:
regsvr32 Microsoft.PowerBI.OleDb.dll
If the command succeeds, you should see a message that says “Registration succeeded”.
3. Install the latest version of Microsoft.ACE.OLEDB
Download and install the latest version of Microsoft.ACE.OLEDB from the Microsoft website.
4. Disable antivirus software
Your antivirus software may be blocking Power BI Desktop from registering the Microsoft.PowerBI.OleDb provider. Try disabling your antivirus software temporarily and see if that resolves the issue.