Power BI gateway cannot connect to Jira on premise

[yaronklein]

Hi everyone,

I have a Power BI report that uses Power BI connector plugin (by Alpha Serve) to connect to our Jira on premise.

It uses oData feed and the url looks something like that – “https://jira.CompanyName.com/plugins/servlet/biconnect/odata/...”

Because Jira is on premise and requires access rights and VPN, I was planning to use a gateway.

The problem is that the Power BI server doesn’t recognize the need for a gateway and provide the following message and all options are disable:

Our assumption is that Power BI server checks if there is a response from this DNS Record on the URL and if there is then it decides that a gateway is not needed.
In our case, https://jira.CompanyName.com has a published public DNS record for an integration with AHA, so there is a responce, but it will not work.

Any ideas about how to solve this?

Do you know if there is a way to force a gateway connection on Power BI service side?

Thanks,
Yaron

[arvindsingh802 · Accepted solution]

Have you configured you gateway ? If not Install an on-premises data gateway | Microsoft Docs
If Yes - Add a new datasource in Gateway Add or remove a gateway data source - Power BI | Microsoft Docs

Once added you will be able to see this under gateway section of dataset settings

[yaronklein]

I tried both personal and standard gateway and it works fine with other data sources that are local.
However, the problem that the Power BI service thinks that for this specific oData, I don't need a a Gateway and this is I beleive is the root of the problem.

[arvindsingh802]

Please follow below steps

1. Install Power BI connector plugin (by Alpha Serve) on Gateway server

2. Create an oData data source under your Gateway using exact same URL as using in power BI desktop

3. You will automatically be getting option to pick gateway datasource

[yaronklein]

Thanks arvindsingh802 ,
I am not sure what you mean to install the conenctor plugin on the Gateway as it installed on Jira.
Also, when I create my oData data source, I am doing it from Jira web pages, so what does it mean to do under the gateway?
Can you please be more specific.

[arvindsingh802 · Accepted solution]

Have you configured you gateway ? If not Install an on-premises data gateway | Microsoft Docs
If Yes - Add a new datasource in Gateway Add or remove a gateway data source - Power BI | Microsoft Docs

Once added you will be able to see this under gateway section of dataset settings

[yaronklein · Accepted solution]

Hi arvindsingh802,
The problem was finally solved and you were right, however I would like to add a detail - I used personal gateway and this option is not part of the personal gateway, only the standard one. 
Thanks,
Yaron