Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RupeshRahate
Regular Visitor

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. However, we encountered an issue during the installation, specifically when attempting to schedule refreshes.

 

The message indicates that a gateway might not be necessary for this semantic model since all its data sources are in the cloud. Still, it suggests using a gateway for enhanced control over the connection.

 

Our concern is, without installing the gateway, how can we ensure that the dataset gets refreshed?

 

RupeshRahate_1-1700117631663.png

Thank you in advance.

1 ACCEPTED SOLUTION
RupeshRahate
Regular Visitor

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.

View solution in original post

4 REPLIES 4
RupeshRahate
Regular Visitor

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.

RupeshRahate
Regular Visitor

Hello @v-xiandat-msft , 

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?Screenshot (234).png

Hi @RupeshRahate ,

Odata data sources generally have the following authentication methods: Anonymous , basic , key, OAuth2.

vxiandatmsft_0-1700206455317.png

 

vxiandatmsft_1-1700206455326.png

 

I used anonymous authentication and it can be configured successfully

Below is the Microsofts 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.

v-xiandat-msft
Community Support
Community Support

Hi @RupeshRahate ,

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.

vxiandatmsft_0-1700126700889.png

Below is the Microsofts 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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors