So I had used Power Query to create my date table. I like to keep the Excel file cleanish. HOWEVER… somehow the powerquery date table is now read-only and I need to edit the M code to add 4 more years. An easy task if it was not forced into read-only mode. Is there any way to save this. I have hours of work on this, and super lazy to want to restart. Working with workarounds for now, but running into an issue that would be fixed if I had them connected to the date table.
If i unload and load it back in and try to reset the connections the datamodel pretty much dies. I am assuming it is the sameperiodlastyear formulas.