Using Excel data that changes / hides columns

[TotunG]

Hello,

I have a fairly simple BI to make but the issue lies with the fact the source data has a process of hiding columns as the date progresses which tends to break the query/other Power Queries. 

Is there anyway round this or do you think the data process will have to change?

[amitchandak]

@TotunG ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

If you doing an unpivot in power query for dates, then select the column you need and do unpivot others

Appreciate your Kudos.

[TotunG]

Hello,

AB	AC	AD	AE
07/11/22	14/11/22	21/11/22	28/11/22
1000	500	111531	341
2000	222	535	4121

In the above, once the week passes (like 07/11/22) this will be 'hidden' by the user via Excel (hide column). This then breaks the query.

Any solution around this?