Clear Data Source Permissions: Difference between revisions
Jump to navigation
Jump to search
Created page with "After updating your credentials in Microsoft Power BI or Microsoft Excel, if you're still getting Error 7001,..." |
m edited content, added information about model auth, and feed auth levels |
||
| Line 1: | Line 1: | ||
After updating your credentials in [[Microsoft Power BI]] or [[Microsoft Excel]], if you're still getting [[OdataLink Error Code 7001: User login does not exist|Error 7001]], you will need to Clear Permissions for that data source in Data Source Settings | When your [[Models|Model's]] [[Model Login Type|'''Login Type setting''']] is set to '''Basic''', Excel or Power BI saves your username and password to authenticate automatically when connecting to [[OData Feeds|OData Feed]]. | ||
For the authentication to work correctly, your credentials must be saved at the correct URL level. User credentials are only valid from the account-level address onwards (e.g. '''<nowiki>https://data.odatalink.com/my-account</nowiki>'''). | |||
If the credentials for accessing account-level data were saved against the root address (https://data.odatalink.com/). the system will attempt to authenticate at root level, resulting in error. | |||
After updating your [[OData Feeds|OData Feed's]] credentials in [[Microsoft Power BI]] or [[Microsoft Excel]], if you're still getting [[OdataLink Error Code 7001: User login does not exist|Error 7001]], you will need to '''Clear Permissions''' for that data source in Data Source Settings | |||
= Steps = | = Steps = | ||
# Go to Data Source settings | # Go to Data Source settings | ||
## [[Microsoft Power BI]] Users: Click on | ## [[Microsoft Power BI]] Users: Click on Transform Data dropdown in Home menu and then the '''''Data Source settings''''' option. | ||
## [[Microsoft Excel]] Users: Click on the Get Data button, then select Data | ## [[Microsoft Excel]] Users: Click on the Get Data button, then select '''''Data Source Settings'''''. | ||
# Select the required | # '''Data Source Settings''' dialog box will appear. Select the '''''Global Permissions''''' radio button from the top of the dialog box. | ||
# Select the required OData source from the list of saved data sources. It would be of the format: '''<nowiki>https://data.odatalink.com/</nowiki>'''. | |||
# Click on '''Clear Permissions''' button. | # Click on '''Clear Permissions''' button. | ||
# A new '''Clear Permissions''' dialog box will be displayed. Click on '''Delete''' button. | # A new '''Clear Permissions''' dialog box will be displayed. Click on '''Delete''' button. | ||
# Now close all the dialog boxes and '''Refresh''' your report. | # Now close all the dialog boxes and '''Refresh''' your report. You will be asked to enter your credentials again. | ||
# Enter your credentials, select the '''''Account level''''' feed or below from the '''Level''' dropdown, and click '''Save'''. | |||
= Related Topics = | = Related Topics = | ||
Revision as of 22:04, 4 May 2026
When your Model's Login Type setting is set to Basic, Excel or Power BI saves your username and password to authenticate automatically when connecting to OData Feed.
For the authentication to work correctly, your credentials must be saved at the correct URL level. User credentials are only valid from the account-level address onwards (e.g. https://data.odatalink.com/my-account).
If the credentials for accessing account-level data were saved against the root address (https://data.odatalink.com/). the system will attempt to authenticate at root level, resulting in error.
After updating your OData Feed's 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
- Go to Data Source settings
- Microsoft Power BI Users: Click on Transform Data dropdown in Home menu and then the Data Source settings option.
- Microsoft Excel Users: Click on the Get Data button, then select Data Source Settings.
- Data Source Settings dialog box will appear. Select the Global Permissions radio button from the top of the dialog box.
- Select the required OData source from the list of saved data sources. It would be of the format: https://data.odatalink.com/.
- Click on Clear Permissions button.
- A new Clear Permissions dialog box will be displayed. Click on Delete button.
- Now close all the dialog boxes and Refresh your report. You will be asked to enter your credentials again.
- Enter your credentials, select the Account level feed or below from the Level dropdown, and click Save.
Related Topics
How to reset security permissions linked to the OData Feeds in Excel