Forum Discussion
How to set up schedule refresh for Odata datasource?
- Anonymous2 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.
Hello Anonymous ,
Thank you for your assistance. We attempted to use all possible login credentials as per your suggestion, but we are still encountering the same errors. Could someone please help me understand which specific credentials I should enter?
- Anonymous2 years agoNot applicable
Hi Anonymous ,
Odata data sources generally have the following authentication methods: Anonymous , basic , key, OAuth2.
I used anonymous authentication and it can be configured successfully
Below is the Microsoftās official link:
Authentication with a data source - Power Query | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.