Excel 2019 Power Query problem

Copper Contributor

I use a power query for a site and grab 1 particular table from the site. I typically refresh the query multiple times throughout the day. However, at some point in the day, or sometimes the next day, the table changes numbers or positioning and messes up the query. i.e- When i did the query it is "table 10" but the next day it might be in a different spot on the site and listed as "table 12" which then I have to go in a edit again. Any help with this issue? Thanks

P.S.- this is windows 10 desktop

0 Replies