Forum Discussion
Refresh from Gateway wrong. but manual refresh correct... need help
i actually figured it out through a long process of elimination. i have a "production schedule" in a google sheet that is updated by the sales team. i then had a seperate google sheet that created a flat file from the Production schedule. well google sheets will automaticlaly refresh between sheets but only if the data is changed from the source sheet. well if noone updated the production schedule in 24 hours then it never refresh the flat file in the other google sheet. for some reason it was then pushing an old data set or something to power BI. the way i fixed this was by adding the flat file into the production schedule. then i didnt have the issue of the two google sheets refreshing as the flat file was now coming from the source document.
Hopefully this helps someone else who ever runs into this problem. a failry niche issue but none the less hope it was helpful.
i actually figured it out through a long process of elimination. i have a "production schedule" in a google sheet that is updated by the sales team. i then had a seperate google sheet that created a flat file from the Production schedule. well google sheets will automaticlaly refresh between sheets but only if the data is changed from the source sheet. well if noone updated the production schedule in 24 hours then it never refresh the flat file in the other google sheet. for some reason it was then pushing an old data set or something to power BI. the way i fixed this was by adding the flat file into the production schedule. then i didnt have the issue of the two google sheets refreshing as the flat file was now coming from the source document.
Hopefully this helps someone else who ever runs into this problem. a failry niche issue but none the less hope it was helpful.