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.
Hi Anonymous ,
The main problem of your refresh failure is that your Odata data source credentials are invalid, just try to update the credentials.
For cloud sources, it can generally be refreshed directly without a gateway. If you want to see whether refresh history , you can check the refresh history.
Below is the Microsoft’s official link:
Data refresh in Power BI - Power BI | 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.