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.
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.
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.
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.
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.
In addition, you can follow the steps in below screenshots to access Advanced Editor:
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.