Forum Discussion
PowerBI Desktop to Service Refresh
Hi AppleMan -you can ask the users managing the SharePoint Excel file to name the columns with Today and Today + 30 headers. These names should remain static so that Power BI can map to them consistently.
Example headers: Today and Today+30.
If enforcing this change is feasible, it eliminates the problem entirely.If possible, enforce standardized headers in the source file. If not, use Power Query to either ignore or dynamically handle the problematic columns. These solutions will prevent refresh failures and ensure smooth operation in the Power BI Service.
ref links:
Refresh breaks due to COLUMN NAME CHANGES? 3 ways to fix changing column headers in Power BI!
Dynamically remove columns that contain a specific word in the header in Power Query – Curbal
Hi AppleMan -you can ask the users managing the SharePoint Excel file to name the columns with Today and Today + 30 headers. These names should remain static so that Power BI can map to them consistently.
Example headers: Today and Today+30.
If enforcing this change is feasible, it eliminates the problem entirely.
If possible, enforce standardized headers in the source file. If not, use Power Query to either ignore or dynamically handle the problematic columns. These solutions will prevent refresh failures and ensure smooth operation in the Power BI Service.
ref links:
Refresh breaks due to COLUMN NAME CHANGES? 3 ways to fix changing column headers in Power BI!
Dynamically remove columns that contain a specific word in the header in Power Query – Curbal
How would you go about ignoring or handling the problematic columns?
What I tried was removing the columns in power query, however once the excel formula changes it to a different column value (ie. 1/1/25 to 1/2/25) then the refresh breaks in service and says it cant find the column value 1/1/25.
