Clear Data Source Permissions

After updating your credentials in Microsoft Power BI or Microsoft Excel, if you're still getting Error 7001, you will need to Clear Permissions for that data source in Data Source Settings

Steps

1. Go to Data Source settings
   1. Microsoft Power BI Users: Click on File, select Options and Settings and then Data Source Settings.
   2. Microsoft Excel Users: Click on the Get Data button, then select Data Sources Setting.
2. Select the required Odata source.
3. Click on Clear Permissions button.
4. A new Clear Permissions dialog box will be displayed. Click on Delete button.
5. Now close all the dialog boxes and Refresh your report.
6. You will be asked to enter your credentials. Enter your credentials and click Save.

Related Topics

How to reset security permissions linked to the OData Feeds in Excel

Login Types