Forum Discussion
How to add dynamic columns to existing table
I have build report which is working fine in the local desktop powerbi app. Now after scheduling refresh its failing with an error "
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
The '<oii>1/25/2025</oii>' column does not exist in the rowset.
"
I have dates as columns in my report which change dynamically everyday as it fetches latest 30 days data. how to automatically add the new columns to the report everyday and bypass the issue of report looking for the deleted date column that wipes off after refresh, meaning dates out of latest 30 days will be not loaded into the report. Please suggest a resolution.
6 Replies
TomOsResolver I
The issue happens because Power BI expects a specific column that no longer exists in your dataset. Since your report dynamically pulls the last 30 days of data, old date columns disappear, causing the refresh to fail.
The best way to fix this is to restructure your data so dates aren’t column headers. Instead, unpivot the table so that each row has a Date column. This way, Power BI doesn’t rely on specific column names and dynamically adapts as new dates appear. If restructuring isn’t an option, modify your Power Query M code to use Table.UnpivotOtherColumns, allowing Power BI to handle dynamic columns better.
How to achieve this ? "if restructuring isn’t an option, modify your Power Query M code to use Table.UnpivotOtherColumns, allowing Power BI to handle dynamic columns better."
v-saisrao-msftCommunity Support
Hi ShashankPala,
I wanted to check if you had the opportunity to review the information provided by MattiaFratello . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
- MattiaFratello
Super User
Hi ShashankPala, you could unpivot your columns in Power Query.
Instead of keeping dates as column headers, transform your data into a row-based structure so that new dates automatically appear as rows instead of new columns.
- Go to Power Query Editor
- Select all date columns
- Click Transform → Unpivot Columns
If you are using a DB you could also change the column names within your query dinamically
- v-saisrao-msft
Hi ShashankPala,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
