How to Edit or Clear Permissions for an Existing Data Source Connection in Power BI Desktop?
- theCode4
When connecting Jira data to Microsoft Power BI using the Data Processor for Jira app, generating API tokens is essential for a smooth and secure connection. If you're working with multiple Jira instances, each with its own API token, you might encounter an issue in Power BI. Specifically, while setting up the data source for one Jira instance works fine, attempting to do so for another instance with a different API token might result in an error before you even reach the authentication stage. The error may appear as follows:
To solve this issue, we suggest either clearing existing permissions to establish new connections or manually editing the permissions for the problematic connector. For step-by-step instructions on how to achieve this, please refer to the guide below.
Clearing Permissions
Open Microsoft Power BI Desktop, and within the application, go to the ‘File’ menu. From there, choose ‘Options and settings’ and then select ‘Data source settings’.
Then, under the ‘Global permissions’ tab, identify and select the data sources you wish to manage (we advise selecting all permissions related to the Data Processor usage) and hit the 'Clear Permissions' button.
In the pop-up window that appears, confirm the action by clicking the 'Delete' button to clear the permissions.
This action will delete the current permissions, enabling you to establish fresh connections with data sources across different Jira instances.
Important: When creating new connections, it's essential to generate unique API tokens for each Jira instance. Also, make sure that the API tokens are linked to the appropriate email addresses for their respective Jira instances. This is vital for ensuring that your connections are set up correctly.
Editing permissions
Open Microsoft Power BI Desktop, and within the application, go to the ‘File’ menu. From there, choose ‘Options and settings’ and then select ‘Data source settings’.
Next, navigate to the ‘Global permissions’ section, select the data sources you want to manage, and click on the 'Edit Permissions' button.
In the pop-up window that appears, select 'Edit'.
In the subsequent pop-up window, under the Basic section, input your new credentials and hit the 'Save' button.
These steps are designed to address the 'Error' mentioned at the start of this guide. However, if you encounter further questions or issues, don't hesitate to raise a request in our Help Center for more assistance.
If you've had the chance to use the Data Processor for Jira - Multi BI Connector and Advanced Exporter app, we'd love to hear your thoughts. Help us improve by sharing your honest review of the Free, PRO or Xray versions. Your feedback is crucial as we strive to improve and tailor our services to better meet your needs.
Still have questions? Feel free to reach out to us for any additional information or to request new features!