powerbi data source error using JIRA powerBI connector

Hi AgileWorld,

Thank you for reaching out to the Microsoft Fabric Forum Community. Thanks to Poojara_D12  and GilbertQ  for Prompt and helpful responses.

You don’t need to install any ODBC drivers if you’re using the JIRA connector with OData in Power BI. OData and ODBC are completely different, and your setup doesn’t rely on ODBC at all.

If your JIRA is cloud-based, you usually don’t need to use a gateway. Just go to the Power BI Service, find your dataset, and update the data source credentials. Most of the time, it works with Basic or Anonymous authentication. Also, make sure the privacy level for the data source is set to Public to avoid permission issues.

However, if your JIRA is hosted on-premises (inside your company’s network), then you do need a data gateway. This gateway must be installed on a machine that can access your JIRA server. Make sure the gateway is up and running, and then go to the Gateway settings in Power BI Service and add the JIRA OData URL as a data source. Below documentations may help in resolving the issue.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

https://learn.microsoft.com/en-us/power-query/connectors/odata-feed

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

Best regards,
Prasanna Kumar

Hi AgileWorld,

Just following up to see if the responses provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar