Resolving 'Data Sources.xml is corrupt' Error in Reporting Intelligence

Issue

When launching Excel with Reporting Intelligence, you may encounter the following error:

The Jet settings file C:\Users\<YourUsername>\AppData\Roaming\Reporting Intelligence\Data Sources.xml is corrupt.

The following error was reported:

This error typically indicates that the Data Sources.xml file used by Reporting Intelligence has become corrupted and needs to be recreated.

Resolution Steps

1. Close Excel.

2. Open Windows File Explorer.

3. Enter %appdata% in the address bar and click enter on the keyboard. This brings you to

   C:\Users\<YourUsername>\AppData\Roaming\

4. Open the Reporting Intelligence folder and delete the Data Sources.xml file.

5. Open Excel.

6. Go to Jet > Settings > Data Source Settings and recreate your data source(s) or export them from another user and import them locally.

7. If you export or import from another user and are using a Dynamics 365 Business Central (Web

   Services) public cloud data source then make sure to re-authenticate your account in the Authentication tab afterwards.

Additional Notes

• If you're unsure how to export or import data sources from another user, refer to Reporting Intelligence documentation or contact your system administrator.

• Always back up your settings before making changes.