Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mkoenig69
Employee
Employee

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

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. 

7 REPLIES 7
v-yiruan-msft
Community Support
Community Support

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

 

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mkoenig69
Employee
Employee

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
Advocate V
Advocate V

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
Employee
Employee

I see this one:

pbi error2.JPG

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:

transform data.jpg

Advanced editor.jpg

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vidyadutt
Advocate V
Advocate V

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
Employee
Employee

bpi error.JPG

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.