cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shane86
Frequent Visitor

Refresh from Gateway wrong. but manual refresh correct... need help

whenever my schedule gateway refresh does the refresh it pulls in the wrong data. however when i go and manually click on refresh it pulls in everything ok. Anyone else have this issue? is this a gateway issue? is it a probablem with the source data? is driving me crazy as i have to continually go in and manually update the data. people are losing faith in the dashbaord...

1 ACCEPTED SOLUTION
Shane86
Frequent Visitor

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.

View solution in original post

3 REPLIES 3
Shane86
Frequent Visitor

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.

v-stephen-msft
Community Support
Community Support

Hi @Shane86 ,

 

Could you tell me what's your data source?  And are you using on-premises data gateway or personal mode? Please check if the gateway is updated to the latest version and also check if the PBIEgwService is always running on your server. 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

GilbertQ
Super User
Super User

Hi @Shane86 


How often is the data refreshing.


Can you also make sure that the parmeters are the same in the Power BI Service as to what you have in your PBIX file?


And finally can you make sure that your data source in the Gateway is pointing to the same source in your PBIX file?





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors