Regenerating Report Credentials

Your Tugger Report Credentials (Username and Password) are used by Power BI, Tableau, and Excel to connect to your data via OData. You can regenerate these at any time, which creates a new Username and Password and immediately invalidates the old ones.

When to regenerate

You should regenerate your credentials if:

• A team member who had access to the credentials has left your organisation
• You suspect the credentials have been shared with someone who shouldn't have them
• You're asked to do so by the Tugger team as part of troubleshooting

How to regenerate

1. Log in to Tugger at tuggerapp.com
2. Navigate to your connector and select Report Credentials
3. Click Regenerate Username and Password

Your Username and Password will be updated immediately. The OData URL stays the same.

Important: Once you regenerate, the old credentials will stop working straight away. Any reports connected using the old credentials will fail to refresh until you update them.

Updating credentials in Power BI Desktop

After regenerating, you'll need to update the stored credentials in Power BI Desktop.

1. Open your report in Power BI Desktop
2. Go to File > Options and Settings > Data source settings
3. Find the Tugger OData entry in the list and click Edit Permissions
4. Click Edit under Credentials
5. Make sure Basic is selected on the left
6. Enter the new Username and Password from Tugger's Report Setup page
7. Click Save
8. Close the dialogue and click Refresh in the Home ribbon to confirm it's working

Updating credentials in Power BI Service

If you've published your report to Power BI Service, you'll need to update the credentials there too, otherwise scheduled refreshes will fail.

1. Go to Power BI Service
2. Open your Workspace and find the dataset (not the report)
3. Click the Settings icon (gear) or hover over the dataset and click Schedule refresh
4. Under Data source credentials, click Edit credentials
5. Set the authentication method to Basic
6. Enter the new Username and Password
7. Click Sign in

Your next scheduled refresh (or manual refresh) will use the new credentials.

Updating credentials in Excel

If you've connected Excel to Tugger via OData, you'll need to update the stored credentials there too.

1. Open your Excel workbook
2. Go to the Data tab and click Get Data > Data Source Settings
3. Find the Tugger OData entry and click Edit Permissions
4. Click Edit under Credentials
5. Enter the new Username and Password
6. Click Save, then refresh your data

Related articles:

• Connecting Power BI Desktop to Tugger
• Publishing to Power BI Service
• Connecting Excel to Tugger
• Report Refresh Errors