cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Delid4ve
Impactful Individual
Impactful Individual

SQL (OnPrem) - Refresh Data Bug

Something not quite right with data gateway service.

 

Load SQL data into a collection

change data in collection

patch data back to sql and clear collection

refresh datasource

load data into collection again

 

the changes are not populated even though they have been patched and the data source refreshed.

In order to load the changes i am having to do

refresh datasource

collect

clear collection

refresh

collect

 

there is definitely a bug here can somebody please advise. its not right that the datasource is not refreshing until the 2nd collect. and ive tried multiple refreshes and it makes no difference

12 REPLIES 12

That did the trick for me as well.  I guess I should probably read the details a little further next time.  Here's a before and after screen capture:

 

https://www.youtube.com/watch?v=VMP5-Nl0r7w

Delid4ve
Impactful Individual
Impactful Individual

I think maybe we need a link next to each experimental/preview feature that takes us to known issues and bugs for each one, this can be updated when things are fixed / reported. Think that’s about the third time one of them has broken something without me realising.

Delid4ve
Impactful Individual
Impactful Individual

Has this been added as a default now?

I seem to be back to this situation, however the option is no longer there...

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,704)