Some users describe getting Access to the resource is forbidden error message when connecting Power BI with data resources.
...
...
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
📘 Reasons:
SSO enabled. While internal Jira users are able to authenticate on Power BI Desktop, SSO users are receiving authentication errors. Try solution.
Wrong credentials. During the first connection, wrong credentials were provided and saved for Data Source
...
.
Captcha at Jira’s side. A rare case that may arise after several unsuccessful attempts to access the Data Source from Power BI Desktop providing the wrong password.
...
| Info |
|---|
...
There are some options to resolve the problem. Some of them can be performed only by Jira Administrator.
Create a local Jira user account, grant this user permission to work with the connector. Afterward, SSO users can create connectors from their usual Jira accounts and share them with that local users' accounts and use the local user's credentials for exporting Jira data into Power BI Desktop. Please note that all data can be exported according to Jira permission schemes.
Install “API Tokens for Jira” or "API Token Authentication Jira" apps. Creating and using Authentication Tokens resolves the issue with the “Access to the resource is forbidden” error.
Use Jira Personal Access Tokens to connect. Jira Personal Access Tokens can be created by users under the users' Profile and can be used instead of the password while connecting via the OData feed under the Basic authorization option. Please note: username should be left empty while using this connection option.
...
How to fix the Access to the resource is forbidden error if wrong credentials were provided?
📘 Solution:
...
At the
...
top-left corner of Power BI Desktop, select the File tab.
...
Select Options
...
, and then select Settings.
Select Data Source Settings.
Select the data source the
...
“Access to the resource is
...
forbidden” error arises for.
...
From the drop-down menu, select the Clear Permissions option.
...
Select the Close button.
...
Afterward, you can re-enter the
...
correct credentials when
...
connecting the
...
data source
...
using Basic authentication.
How to fix the
...
Access to the resource is
...
forbidden error if a captcha appeared?
📘 Solution:
Log out from Jira and try to login again.
Confirm Captcha during the login if present.
Alternatively, Jira Admin can always check and confirm the captcha under the User Management admin section.
...
Afterward, provide valid credentials when trying to connect the required data source through Basic authentication.