Clear Data Source Permissions: Difference between revisions

(2 intermediate revisions by the same user not shown)

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 and 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, https://data.odatalink.com/my-account/model-code</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 =

# Go to Data Source settings

## [[Microsoft Power BI]] Users: Click on ~~File, select Options and Settings~~ and then 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 ~~Sources Setting~~.

## [[Microsoft Excel]] Users: Click on the Get Data button, then select '''''Data Source Settings'''''.

# Select the required ~~Odata~~ source.

# '''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.

# 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.

# You will be asked to enter your credentials. Enter your credentials and click '''Save'''.

# Enter your credentials, select the '''''Account level''''' feed or below from the '''Level''' dropdown, and click '''Save'''.

= Related Topics =

@@ 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 and 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, https://data.odatalink.com/my-account/model-code</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 =
 # Go to Data Source settings
-## [[Microsoft Power BI]] Users: Click on File, select Options and Settings and then 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 Sources Setting.
+## [[Microsoft Excel]] Users: Click on the Get Data button, then select '''''Data Source Settings'''''.
-# Select the required Odata source.
+# '''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.
 # 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.
-# You will be asked to enter your credentials. Enter your credentials and click '''Save'''.
+#  Enter your credentials, select the '''''Account level''''' feed or below from the '''Level''' dropdown, and click '''Save'''.
 = Related Topics =