Home Forums Power Pivot What import methods allow me to change a Calendar table?

This topic contains 1 reply, has 1 voice, and was last updated by  Charley 1 week, 6 days ago.

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

    Charley
    Participant
    • Started: 8
    • Replies: 5
    • Total: 13

    In Excel 365, have a calendar table in one workbook, and in another workbook, I’m using Power Query to load the Table to the Data Model. When I view the last line of my short query in the data workbook, I have the fields I expect in the order I expect.

    In the Calendar table in the Data Model, however, I have fewer fields than my query returns, and the ones I do have are in a different order. (And yes, the Import Data dialog has the add-to-data-model checkbox checked.)

    When we use PQ to load data to the DM, are we not allowed to add fields or change their order? (I thought that only copy-and-paste had such a limitation.)

    How can I load a calendar table so that I can add fields and rearrange columns as needed?

    Thanks

    Charley

    #12485

    Charley
    Participant
    • Started: 8
    • Replies: 5
    • Total: 13

    Strange. Re-creating data workbook from scratch gave me all the fields.

    But I had to rearrange the Data Model fields manually to put them in sync with the query.

     

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

You must be logged in to reply to this topic.