Forum Discussion
Is 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,
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,
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's
In 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.