none
Bug in new PowerQuery 2.22.4007.242 when used together with PowerPivot (was fine on v. 2.21): EmbeddedMashup changes with every save RRS feed

  • General discussion

  • Hi,

    I have an issue with this latest update, when working together with PowerPivot.

    Here’s my setup: Excel 2010 64bits + PowerQuery_2.22.4007.242 x64 + PowerPivot for Excel SP2 x64

    When trying to refresh an existing excel that has PowerPivot use a PQ data source (via the Existing Connections menu item), I get a refresh error. I have been able to pin down the error to the following:

    Every time I **SAVE** (not before saving) the workbook, the EmbeddedMashup connection sting of PQ changes (with PQ 2.22). This did not happen with PQ 2.21. With this happening, the PowerQuery refresh breaks.

    Example:

    BEFORE: Working: Excel with PowerQuery 2.21

    Workbook PowerQuery Connection:
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(7bd72702-510c-4616-a072-c970477e94c8)$;Location=Query1; (…. rest of string does not change )

    PowerPivot data connection:
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(7bd72702-510c-4616-a072-c970477e94c8)$;Location=Query1; (…. rest of string identical )

    The two “$EmbeddedMashup” strings were identical, and saving the Workbook did not affect them. Nothing strange.

    WITH PQ 2.22 (BREAKS POWERQUERY REFRESHES BECAUSE EMBEDDEDMASHUP CHANGES WITH EVERY SAVE)

    Workbook PowerQuery Connection: (does not change at all)
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(7bd72702-510c-4616-a072-c970477e94c8)$;Location=Query1; (…. does not change )

    PowerPivot data connection:

    Before saving: Original (PowerPivot refreshes work)…
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(7bd72702-510c-4616-a072-c970477e94c8)$;Location=Query1;

    After 1 save: (PowerPivot refresh does NOT WORK anymore): EMBEDDESMASHUP CHANGES!
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(5bafbf30-bfd5-47e0-bdc8-1025438c1992)$;Location=Query1

    After saving again: (PowerPivot refresh does NOT WORK anymore, embeddedmashup changes again)
    Provider=Microsoft.Mashup.OleDb.1;Data Source=$EmbeddedMashup(fd8cb919-e5e5-4f7a-8d59-cc658af29ccd)$;Location=Query1

    … etc

    This breaks compatibility between PowerQuery and PowerPivot. It all worked well with v 2.21. Could you please fix the bug?

    Workarounds I’ve found:
    – Downgrade to v. 2.21
    – Alternatively, copy the whole connection string from PQ to PP. It will make refreshing work, until you save the workbook and it breaks again….

    Thanks for all – and by the way, it is really great that you have included PQ in general O365!

    Best regards

    Martin

    Friday, May 22, 2015 7:53 AM

All replies

  • I can confirm the same bug for my system. The issue also occurs for Excel 2010 32 bit.

    Strange how hard it is to get the Power Pivot connection right.

    Regards

    Wolfgang

    Friday, May 22, 2015 2:45 PM