Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
Ket's just say for example I have the files(multiple excel or csv) that I need in a folder.
When I tried to refresh the query an error appeared, you know one of those "The column Date is missing..." any generic error.
Is there a way for me to check through PowerBI which among those multiple files in the folder is causing the error?
What I usually do is isolation, which I think is a stupid idea - there must be a better way of knowing.
Hi @ovetteabejuela,
What error messages did you get?
Per my knowledge, the most direct way is to connect to those files one by one to find out which file causes connection error.
Besides, you could try to analysis trace log file. Go to File->Option and settings->Options->Diagnostics, checkbox "Enable tracing". Here's a good tool to analysis the logs: Power BI Desktop Trace Logs Analyser
Best regards,
Yuliana Gu
I will give it a try.
This doesn't give me the information I need, I have a sample error but as I said this could apply to any error that arises during "Refresh".
In this scenario I have 5 Excel Files in a folder, they are expected to have the same format but sometimes 1 or 2 may divert form the process and thus an error, the error that was raised this time was:
Okay based on that, how can I easily tell which of the 5 files is causing the error? Could PowerBI just tell me which one of those 5 is causing this? What I'm doing is isolation, group into smaller groups but again as I said that is stupid and non-productive (what if I have hundreds of files in there? That would take a lot of time for me to isolate the problem.
And here's another one...
That "Load was cancelled by an error is loading a previous table" - IS NOT VERY HELPFUL --- which previous table?
I have this issue as well and apart from spending the time to write a specific function or script to find files (I have csv files) that don't have specified column headers, it seems very difficult to find where Power Query ran into an issue and stopped.
Has anyone found a way to work through this?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |