Power BI source step reading excel file showing inconsistent format

[LuciaTan]

Hi, I have a monthly power BI report that gets updated each month. It reads excel file which is outputted by SAS. The format of the excel file for different months should be the same. But the query fails when I try to use last month's source step to read this month's data.

I figure that this has something to do with the excel files. My excel files from last month is much larger than this month's, but by visual inspection I cannot find any difference. The first screenshot is the source step after reading in last month's data, and the second screenshot is the source step after reading this month's data. I notice that last month's has three more columns : Item, Kind, and Hidden. Do you know what this imply about the the excel files and how I should modify this month's excel file so it can be read in the same way? Thank you so much!                               

[HarishKM]

@LuciaTan Hey,
Can you please send the screenshot of your error message ?

or if your all column are same in report then you can load data in seperate table and then append it your old  table to see the current month data.

Thanks
Harish M.
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂

[rrm121812]

Hi LuciaTan,

If you want only Name and Data columns from your data source, you can add a filter step after source which Keeps only these two columns and deletes the rest.

If you find this helpful, please Accept this as a solution.