Home Forums Power Pivot Power Query Date Table


This topic contains 1 reply, has 2 voices, and was last updated by  tomallan 11 months, 2 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #8424

    • Started: 2
    • Replies: 0
    • Total: 2

    Afternoon all,


    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.


    • Started: 7
    • Replies: 2461
    • Total: 2468

    If you have measures linked to your calendar table, you should move the measures elsewhere before removing the calendar table.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.