Is Gateway Needed when I am loading Data from Jira API & Local Excel File

[KR300]

Hi Community, Good Morning/Good Evening,

Current Scenarion: I am axtracting data from Jira API & local Excel.

Question 1: Is it necessary to have a gateway installation to Power BI Report which is having Schedule refresh for every one hour on dialy basis.

Question 2: Is it enough to download the Gateway instally from Power BI service and Apply to my report. Or Do i need to install a separate Gateway ( External Gateway or Personal Gateway )  

[v-jiewu-msft]

Hi @KR300 ,

The method ibarrau provided should be helpful. For the first question, it is necessary to have a gateway installed if you want to schedule a refresh for your Power BI report that includes data from a local Excel file.

For the second question, if you are the only one using the data and reports, the personal mode might be sufficient. However, if having multiple users connecting to data sources or manage multiple data sources, the standard mode would be more appropriate.

You can also view the following document to learn more information.

Refresh a dataset created from an Excel workbook - local - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. This is not an issue about Jira. If you connect just to Jira API, you shouldn't need a gateway at all. However, the local excels demand the onpremise data gateway. You could upload those excels to a Sharepoint. That way all your sources would be cloud and you could refresh without the gateway just configuring the credentials at Power Bi Service.

I hope that helps,

[KR300]

Thanks, @ibarrau  for you Answer.

I will work on the above concept. Will reply to you. Thanks a lot