How to modify Power Pivot data connections in old workbooks?  How to convert to Power Query?
Results 1 to 2 of 2

Thread: How to modify Power Pivot data connections in old workbooks? How to convert to Power Query?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2014
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question How to modify Power Pivot data connections in old workbooks? How to convert to Power Query?

    Hello,

    I only started using PowerPivot after Power Query was readily available. I come across example Excel/PowerPivot documents where the data is embedded into the Data Model and I don't understand how you can modify the connections.

    I found this cool PowerPivot example here on the forum LINK that I'd like to play with but without manually copying the calculations over to a new Excel workbook just so that I can change the input data.

    Could you explain how the connections are made and the data imported? (There are a bunch of Connections in Queries and Connections but it just says Add-in Data Connection. I don't see any "connections" in the Data Tools-> Manage Data Model/PowerPivot window)

    Can you change the data at all? (In the example, some of the tables are really small (ie: XServiceLevel is one column with 9 values))

    Can you convert the connections to PowerQuery? ( In the example, the main callData table was obviously imported from some other program/file)

    Many Thanks,
    Alex

  2. #2
    Board Regular
    Join Date
    Sep 2014
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to modify Power Pivot data connections in old workbooks? How to convert to Power Query?

    I only just noticed that there are Home->Clipboard->Paste Append/Paste Replace buttons. That seems to work to update the data in those connections. Weird that I'm only seeing/noticing them now. ¯\_(ツ)_/¯

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •