Running an append / combine query on a list of Excel files stored …
Dec 12, 2014 · Is there a way of running a Power Query that combines all required rows from a list of Excel files held in the same folder ? I noticed that there was a similar query regarding …
Unexpected Error - Type Initializer for …
I'm a little surprised that the text "Unexpected Error" is in English while the text of the exception message is in Swedish. Which language Power Query addin was installed, and how does it …
Error excel error messages unhandled exception has occurred and …
Do you have the .NET programmability feature enabled? If so, can you try a repair of office and then try installing Power Query? If not, can you add the .NET programmability feature and try …
Combine two files that has inconsistent columns
I would recommend getting the book "Collect, Combine and Transform Data Using Power Query in Excel and Power BI" by Gil Raviv and reading Chapter 4 Combining Mismatched Tables. It …
Power Query/Power Pivot cannot convert negative numbers …
Apr 1, 2014 · Power Query can certainly convert the text "-1" into a negative number, so there's something else going on here. Is it possible, for instance, that the negative sign in the string is …
Importing Text in Excel 2016 - social.technet.microsoft.com
I finally figured it out, there was an update that set the Power Query based tools as the default for importing. I had to go to File>Options>Data and enable legacy import wizards, then on the …
Help! How to find X-value for known Y-value not using trendline?
Apr 14, 2017 · My ultimate aim is slightly bigger than I have explained, I have about 10 different worksheets each containing those tables for a different CBR value. My aim is to have graphs …
Gateway and data source set up but no refresh from local server
Jul 17, 2014 · 4. In Excel, with Power Query I can use the OData feed to get the data from the local server but 5. When the spreadsheet is uploaded to SharePoint, I am unable to refresh …
Formula.Firewall: Query 'x' (step 'Source') references other queries …
I use power query because I need to connect to a database and pull data according to some parameters (taken from an Excel table object). To do this - in the advanced editor - I create a …
Where are the Global Data Source Settings stored?
Aug 12, 2016 · They REALLY need to fix this. Using Power Query in a corporate setting is almost impossible with this connection problem. Thursday, November 30, 2017 1:22 PM