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. It depends on how your power query code is. You can be using cloud sources and still need a data gateway. Let me explain it. When you work your requests with Web.Contents, you can keep your sources online without a gateway. However if you are scrapping a web with Web.Pages function, you must use a gateway. As far as I know, all your sources could work without it, but if you need special transformations for getting data it could be compromised. When using gateway you must to add sources and credentials at the gateway administration. When using cloud sources you must write the credentials at dataset/semanticmodel settings.
I hope that helps,
Helper IIIibarrau Anonymous
Note: My workspace is Premium Capacity
I am using web.contents function in the ( Json.Document(Web.Contents("https://jira.tools.xxxxxxxxxxxxx.us/rest/api/2/search?jql=project%20%3D%20SMAR%20AND%20issuetype%20in%20(bug%2C%20story%2C%20epic)%20and%20fixVersion%20%3D%20" & FixVersionName & "&maxResults=1000&fields=key,summary,fixVersions,priority,status,components,issuetype"))
and getting the data from API's
Note : All are cloud data
Questions:
1. Do i need a Gateway installation here? If yes, why beacuse i am using data from cloud, right?
2. If we don't need a gateway then why the Data soure credential option + Refresh Option are greyed out?
3. If i don't need a gateway, do i need to login or must be in online while refreshing the Semantic model in service?
4. If still I no need a gateway, I am not able to set up a schedule refresh even though my workspace is backed by Premium capacity.
- ibarrau
Hi. Two things here. First try ro recreate you web.contents with good practices like relativepath or query like this: https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
Second and most important, it sounds like the issue could be the sharepoint/onedrive. Please check this video out: https://www.youtube.com/watch?v=CYSMZxaXNLk
I Hope that helps,
- KR300
ibarrau Anonymous ,
Actually I just tried with Only Sharepoint/One drive data source, i am able to refresh + set up the schedule refresh without a gateway here.
I think the problem is here Jira & Other API'sIn my work: If i login to Jira i must coonect to a VPN then only able to login to jira and see/check my user stories & tasks ( Is it related to Public API's or Private API's or an VPN connection ? )
2. I just tested it ( I turned off/disconnected the VPN, then i refreshed the sematic model manually, failed. again turned on/connected the VPN - refreshed the sematic model manually , success.