Forum Discussion
Dataset refresh has stopped working with different errors each time I try to refresh
Hi Dale,
I am not using a data gateway, I am only connecting to an Azure Functions Proxy that connects to WorkflowMax API:
At the point I wrote the blog everything was working fine, then I added the following changes to my data set:
1. I have a base data set that gets all the data from WorkflowMax/Proxy, so I created a new table based on this data set to get territory.
2. Then on the Job table I am doing a filtering on a column by using List.Contains from a Buffered List (To validate is an existing territory). I basically load the territories on a buffered list to do the comparison, the territory list is not to big it has like 15 fields
So I don't know where the gateway error is coming from.
Many thanks
Hi cecyarmida,
Can you refresh it successfully in the Desktop? Can you share the Power Query code? Please mask the sensitive parts first.
Best Regards,
Dale