Forum Discussion
Power Query Error - PLEASE HELP
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?
stephenjennings Thanks for uploading the file (I removed it as it seemed to contain private and confidential information), but I don't really know where to start looking.
The workbook is so complicated and soooo many queries. Can't test any refresh as the Jobsites query connects to a machine on your own PC. And there are a few more like that. And it seems that you added a column with formulas to the Jobsites PQ table. That's probably not going to work very well.
Then you have a lot of connections to local tables and all you do is filter out a few rows for one person and that you repeat many times. And then you connect to these individual queries again. I'm getting confused right away. Can't really do anything with it. Sorry!