Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to set up schedule refresh for Odata datasource?

Hello Team, We're currently working on generating reports using the OData source from Jira and publishing them in our services. To streamline this process, we considered setting up a gateway. Howeve...
  • Anonymous's avatar
    Anonymous
    2 years ago

    We figured out the solution to this problem after trying many different combinations of usernames and passwords.

     

    We were trying to connect the Jira cloud to the Power BI service. Normally, you don't need gateways for a refresh since both are in the cloud. However, even after trying various combinations of login credentials, we kept getting an error saying the credentials were invalid.

     

    We tried using our organizational username, email, and password. We even tried using the username and password of the Jira tool, but nothing worked.

     

    Then, one of my colleagues tried an unexpected combination of credentials – using the Jira username and an Access token as the password. Surprisingly, this didn't give us an error, but the data still wasn't refreshing.

     

    Finally, we scheduled a refresh, and everything got sorted out. Thanks to everyone who helped us, knowingly or unknowingly.