@jchahal
It sounds like you're experiencing a frustrating issue with missing columns when loading data into Power BI. This type of error typically arises when Power BI expects a column that is either not present or incorrectly referenced in the source data or within the query itself. Here’s how you can troubleshoot and hopefully resolve the issue:
1. **Check the Source Data**: Ensure that the source data still includes the columns that your Power BI query references. If the column structure of your source data has changed (like removing or renaming columns), you will need to update your Power BI queries accordingly.
2. **Refresh the Query in Advanced Editor**: Open the Advanced Editor from the Home tab in Power Query Editor. Review the M code to see if there are any steps specifically referring to column indices that no longer exist. Columns in M code are often referred by their position, like `Column1`, `Column2`, etc., which can lead to errors if the data structure changes.
3. **Use Column Names Instead of Indices**: To prevent this issue in the future, modify your query to reference column names instead of column indices. This way, if the order of columns changes, it won’t impact your queries. You can do this in the Advanced Editor by replacing column indices with the actual column names.
4. **Error Handling**: Implement error handling in your Power Query by using the `try otherwise` structure in M code. This can help in bypassing errors related to missing data or columns, allowing the rest of your data to load successfully.
5. **Revert to Previous State**: If you made changes to your model or queries recently, consider reverting to a previous version where the error was not present. This might help isolate the change that caused the issue.
6. **Review Applied Steps**: In the Power Query Editor, carefully review each step in the Applied Steps pane. Sometimes, removing or modifying steps related to column removal or transformation can solve the issue.
Try implementing these changes and see if it resolves the column not found error. If you continue to experience issues, it might be helpful to share the specific M code or a screenshot of the error and the Applied Steps pane for more targeted advice.
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
