+ Reply to Thread
Results 1 to 6 of 6

I need to recover a PowerPivot query from a corrupt xlsx document

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    Salt Lake City, UT
    MS-Off Ver
    2016 32 bit
    Posts
    13

    Unhappy I need to recover a PowerPivot query from a corrupt xlsx document

    I need to recover the query text from my Excel document. I'm digging through the zipped structure of the xlsx file and am trying to find the text of the query to try to salvage it... . It took a lot of work to construct, and I don't want to have to rewrite it. Does someone know what internal file contains the query or how I can recover it from a corrupted xlsx file? I don't need the results (which are huge) - I need the actual query text.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: I need to recover a PowerPivot query from a corrupt xlsx document

    It's stored in /customXml/itemxx.xml

    Use Windows Search tool and look in files for "DataMashup".

    Then create a new Excel file. Change file extension, to zip. Extract to some location.

    Create /customXml folder in it. Copy itemxx.xml file into it. Zip it and change the extension back to xlsx.

    EDIT: When I saw query. I assumed it was PowerQuery. If you mean data model and DAX for PowerPivot...
    Try copying connection.xml along with All pivotCacheDefinitionX.xml into new file as above.
    Last edited by CK76; 09-06-2019 at 03:41 PM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-25-2019
    Location
    Salt Lake City, UT
    MS-Off Ver
    2016 32 bit
    Posts
    13

    Re: I need to recover a PowerPivot query from a corrupt xlsx document

    Thanks. This is from a query I added via Get Data>From SQL Server Database> (custom query with the selections "Create Connection only" and "add to data model"). The text in that query (rather than all of the PowerPivot and data-modeling formulas).

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: I need to recover a PowerPivot query from a corrupt xlsx document

    Ok then first method should get you to load it to new workbook and copy out the query.

  5. #5
    Registered User
    Join Date
    07-25-2019
    Location
    Salt Lake City, UT
    MS-Off Ver
    2016 32 bit
    Posts
    13

    Re: I need to recover a PowerPivot query from a corrupt xlsx document

    Is this going to contain the actual text "SELECT …"? I don't see it in those files.

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: I need to recover a PowerPivot query from a corrupt xlsx document

    It’s encrypted, so you need to copy it to new workbook see the content. Follow my instruction.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Please help recover data from corrupt file
    By juntjoo in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-18-2017, 12:01 AM
  2. How to recover corrupt PPT file
    By sirold1947 in forum PowerPoint Formatting & General
    Replies: 6
    Last Post: 09-30-2016, 01:36 PM
  3. Corrupt excel .XLSX file
    By ArronAd in forum Excel General
    Replies: 5
    Last Post: 04-01-2016, 01:44 AM
  4. How to recover the password of a 2010 Excel(.xlsx) sheet?
    By t_hatcher in forum Excel General
    Replies: 2
    Last Post: 07-30-2015, 08:03 PM
  5. corrupt document and open and repair command
    By chipsoly83 in forum Excel General
    Replies: 4
    Last Post: 12-11-2009, 08:38 AM
  6. [SOLVED] Can i open or recover a corrupt document in 2007
    By jesika in forum Word Formatting & General
    Replies: 1
    Last Post: 04-15-2009, 05:14 AM
  7. is there any way to recover the lost document?
    By yalanola in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-30-2006, 09:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1