PLEASE HELP - Getting "Loading blocked by failures with other queries"

[mkoenig69]

I have a large set of CSV files that load in a PBIT. I have used it many times but for this particular set of data it will not load data. I keep getting this error. I do not know much aout PBI and do not even know where to begin looking for an issue. 

[v-yiruan-msft]

Hi @mkoenig69 ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

Any comment or problem, please feel free to let me know.
Best Regards

[mkoenig69]

I don' t know much about powerBI. I don't know how to use the advanced editor. All the people who wrote the queries in that template are out of the office for the holiday.  I manually moved the data into the proper format in the file but that still didn't work. 

[vidyadutt]

Probably you're referencing the column "TrusteeID" in one of the steps. Try Advanced editor (right click on the query and select Advanced Editor) and see if you're using it. Here is a thread discussing a similar problem, which was fixed by editing the query using Advanced Editor.

https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-of-the-table-wasn-t-found/td-p/...

[mkoenig69]

I see this one:

[v-yiruan-msft]

Hi @mkoenig69 ,

According to the error message, this problem seems to be caused by the deletion or renaming of the column "TrusteeID" of the query Tier0Machines in the data source CSV file. Please compare the corresponding sheet in the CSV file with the fields of the query Tier0Machines of Power BI. You can refer to the following blog to solve this problem by update the applied codes in Advanced Editor.

Power Query: Preventing "The column of the table wasn't found" error

In addition, you can follow the steps in below screenshots to access Advanced Editor:

Best Regards

[vidyadutt]

Hi @mkoenig69,

Looks like you are loading a handful of csv files into the model. Scroll down and go through the messages one by one. In (at least) one of the load, you will be able to locate an error. Then fix it and continue.

Cheers!

[mkoenig69]