There is a lot of helpful information out there on the web about this issue if you look around, though, and that's why I thought it would be useful to bring it all together into one blog post and also pass on some hints and tips about how to recover from this error if you get it. This post has a solution for the same problem in Excel 2010, but it doesn't work for Excel 2013 unfortunately. Please disable and re-enable loading to the Data Model for this query. Here's the error message we got:ĬOM Error: The query 'xyz' or one of its inputs was modified in Power Query after this connection was added. We couldn't refresh the table 'xyz' from the connection 'Power Query - xyz'. You can always ask an expert in the Excel Tech Community or get support in the Answers community.Reposted from Chris Webb's blog with the author's permission.Īnyone who has tried to do any serious work with Power Pivot and Power Query will know about this problem: you use Power Query to load some tables into the Data Model in Excel 2013 you make some changes in the Power Pivot window you then go back to Power Query, make some changes there and you get the dreaded error Power Pivot is NOT included with any of the following: This free download works only with Excel 2010, and not with newer versions of Excel. The Power Pivot add-in for Excel 2010 did not ship with Office, but is available as a free download: Power-Pivot add-in download. Office 2016 Professional Plus (available via volume licensing only) Products with a one-time purchase (perpetual license) Microsoft 365 - All versions that include Desktop versions of Excel for Windows Power Pivot can be found in the following Office products: If you're a Microsoft 365 subscriber, make sure you have the latest updates installed. Power Pivot availability will depend on your current version of Office.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |