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
I am updating a data set on a weekly basis with multiple excel files. Some files are added to a folder and some are connected via onedrive web link.
The files are provided to me by team members and naturally sometimes columns can be missing.
When this happens to the OneDrive web linked files; this throws exception errors related to the missing columns.
I find that when I get data from a folder, if an excel file is missing the correct column it just doesnt load with no error so it can be difficult to troubleshoot when the data doesnt appear in the model.
Is there best practise when setting up a workflow were you are recieving excel data from multiple team members to ensure the data will not cause errors or omissions?
Solved! Go to Solution.
If the missing columns are needed for the report, nothing you can do about that as the data is missing and the report won't work.
However, if these are optional columns that you aren't using, then absolutely! Suggestions:
There are other ways to help make your report more robust. DataChant did a series of Pitfalls in Power Query few years ago and it is still 100% relevant. You can read those, or post back here with some more specific issues you are having.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIf the missing columns are needed for the report, nothing you can do about that as the data is missing and the report won't work.
However, if these are optional columns that you aren't using, then absolutely! Suggestions:
There are other ways to help make your report more robust. DataChant did a series of Pitfalls in Power Query few years ago and it is still 100% relevant. You can read those, or post back here with some more specific issues you are having.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @osabhaois
I can feel that. What I practise is, I used to sent back those files initially and ask them to make the changes and keep the format as it was earlier, though it takes time but that's the best practise.
So ideally they should keep the column name and they might leave it blank if there is no data but the column sequence and names should be similar as they were in last file.
Yeah it woun't show you an explanation for the error, but it would just say load failed or something, but if you'll check the same in Power Query you can find the root cause for the same.
Hope it helps.
Thanks
Ankit
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 |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |