Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...!
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.