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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anette_Munoz
Regular Visitor

Error on scheduled data update

Hi everyone!

I am having issues with the scheduled update, as it applies correctly the first time, but then it shows an error. I have a scheduled update set for different times daily.

Anette_Munoz_1-1726855909218.png

Within my semantic model, I extract information from an Excel table stored in OneDrive and also from a website that shows the exchange rate from Mexican pesos to dollars. This information is updated on the website, as it adds the date of each passing day along with its exchange rate. I would like this to update daily, but as I mentioned, the first update is successful, but the subsequent ones fail, and I get the following error:

Anette_Munoz_3-1726856293658.png

I suspect that the problem originates from the data being extracted from the website, as in other semantic models the update works perfectly with the data from the Excel table in OneDrive

 

How could I solve this issue?

 

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @Anette_Munoz ,

 

WHen you say the first time, do you mean when you upload it?  the error message is stating that your gateway is offline.  Do you have a personal gateway setup to use this data source?  If so, you must leave it on all the time.  This is a great reason to use an Enterprise gateway - those are usually setup to stay on (they are on a server most commonly).




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

If you use a personal gateway (not sure why you would need that?)  then it must be running during the attempted refresh.

collinq
Super User
Super User

Hi @Anette_Munoz ,

 

WHen you say the first time, do you mean when you upload it?  the error message is stating that your gateway is offline.  Do you have a personal gateway setup to use this data source?  If so, you must leave it on all the time.  This is a great reason to use an Enterprise gateway - those are usually setup to stay on (they are on a server most commonly).




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thank you!, was solved with the enterprise gateway

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors