While refreshing data in power bi, table column name change dynamically but report getting collapse

[Anonymous]

We are created the report for maintain the data of next 12 month according current month, also the column name is starting from the current month For Example, Jul/Aug, Aug/Sept, Sept/Oct...... and so on upto next 12 month, In next month cycle we update data in database and refresh the data at Power BI, column name's are getting updated dynamically as per next month cycle For Example Aug/Sept, Sept/Oct, Nov/Dec........and so on upto next 12 month, But after the refresh data or dynamically column changes report getting collapse.

Could anyone please help me on this? Thank you...!

[lbendlin]

There is nothing you can do about that.  Adding new columns to source data is very bad practice. Instead, try to unpivot your source data so the columns stay the same.