Forum Discussion
Power Query Error - PLEASE HELP
I have a excel document with a multitude of queries that reference each other for information. For some reason, the query tables will start to reference the wrong queries and completely throw my whole workbook off when refreshed. When I look at the query properties, even the name of the source data will change. I tried to fix but am finding no luck. PLEASE HELP!!
4 Replies
stephenjennings Well, that's not much to go on. You have a bunch of queries and it goes wrong. Can you please be more specific? Perhaps some screenshots? A shared file demonstrating the issue would be even better.
Riny_van_Eekelen My apologies, I am new to this. The below screenshot is a table called "Jobsites" that loads around 500 jobs with information tied to it. When I refresh it populates the table with only two lines. This is because it is referencing the table "Jobsites_Stone" instead of "Jobsites". The query properties have changed and I do not know how to get the table to reference the right information again so my refresh doesn't break the workbook.
stephenjennings No apologies needed. Not sure, though, how query properties can cause the problem you described. What do you have in the Source step of the referencing query?
