Forum Discussion
Helper IIIIs Gateway Needed when I am loading Data from Jira API & Local Excel File
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,
Super UserHi. 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
Hi ibarrau Anonymous , now data Sources are:
Removed local excel file and placed in the Sharepoint folder
Jira API's ( Connected by Using username/passowrd in pbi desktop )
Other API's ( Connected by Using username/passowrd in pbi desktop )
Github Integration based on API using Token or may be Username/password
I am not able to set up a schedule refresh in the Power bi service
Data source credentials & Refresh Options are greyed out.
1. What is the reason here ( but i have all the data in the cloud right?. If need to login Jira like to see what are my user stories, tasks i have to use user name & password ).
2. After installation and implementation of Personal gateway then only the Data source credentials & Refresh Options are enabled.
3. Is it related to Public API or Private API connection things?
Actually If i login to Jira ( I need to connect to VPN ) - is this causing issue?
