CSV file refresh as datasource

[schoden]

Hi Community, 

I have a CSV file with Months at that particular point of Time and picks only 3 Months as shown( since we are in March 22 it shows only last 3 months) 

The file is stored in Sharepoint and through WebURL in  power Bi it gets the CSV file data .

Say in future the file will change to lastest 3 month data where Dec-21 column gets dropped at the source.

However the the  dataset refresh fails saying Column Dec-21 is not found anymore.

How Can I achieve this case so  the data refreshes as the source changes with column.

Will appreciate any help.

Thank you.

[VijayP · Accepted solution]

@schoden

 Try this

To correct the query error, select Go To Error in the yellow message box, and correct the formula in the formula bar. But proceed carefully. Whenever you change a previous step under Applied Steps in the Query Settings pane, subsequent steps might also be affected. To confirm your fix, refresh the data by selecting Home > Refresh Preview > Refresh Preview.

[schoden]

@VijayP 

Thank you so much ..worked like magic