power query 2016

Hi All, I have two workbooks. They both are directly linked with Oracle Accounting software through Power Query. Every time when we want to see latest data. I have to go to those workbooks one by one. Run the query (once the query has finished running), save the files and close. After that I...

Hi all I would like to use the append function in power query to combine 3 spreadsheets. When I do this manually in the last column I type the type of activity the report contains. Such as booked, shipped, logged. Then this is put into a pivot table. So my question is when I am import the...

I have a spreadsheet that is basically a trimmed down version of my master that gets distributed. To trim it down, I have removed columns and implemented conditional formatting for readability. Needless to say, very complicated (mostly due to the conditional formatting giving the reader pretty...

Hi, I have three tables showing Plant, Material and Labour quantities from each of my crews on site, The tables are linked by unique identifiers or "Shift Report Numbers", however, multiple items assigned to each unique identifier. For example: Shift Report Number Date Job Code Labour...

Hi I have something similar to the below Columns2 Columns3 Columns4 Columns5 Columns6 Columns Transaction null null 1 null null Bank ref null null 1a null null Transaction null null 1 null null Currency null null eur null null Bank Ref null null 2 null null...

Hi, I have an issue with some given VBA code that refreshes the PQ connection to an Access query, but first sets BackgroundQuery to False, in order to be able to wait for the connection to be refreshed and then continues the code. However, when background refreshing is turned on, the query runs...

Experts, I have a macro, GetExcelData (), that retrieves the contents of a single worksheet from a workbook located in a network folder. User clicks a button and, presto, the needed data is deposited in a new worksheet in my affected workbook. Works famously. However, because the macro, based on...

Hi, I have a table containing budgeted foreign sales data by month and want to convert this to a home currency (the fx rate is obtained via a parameter). Is it possible to multiple several columns at once in power query by a value? I know I can create new columns for each month and multiply...

Hi Everyone, I am using Microsoft Office Professional Plus 2016 and Inoticed I am missing some features inside of Power Query. I came across some ofthe missing features while attempting to merge two tables. The merge button inthe queries button does not have the drop down feature to allow the...