- Inserting new rows in Power Query report
- Power Query_Refresh data_Not populating
- Power Query - Transpose Matrix
- Power Query - importing Dynamic Named Ranges ("=Excel.CurrentWorkbook()")
- Conditional Power Query formulas
- Power Query: Associate Each Customer Sale With A Supplier Order ID
- Split Power Queries
- DataFormat.Error in Power Query
- CSV without Carriage Return Importing as Single Column
- Master Power Query with our book - M is for Data Monkey
- Installing Power Query
- Power Query New Versions - How Do I Know?
- adding a column to PQ table
- ISO Date
- Power Query slow and unstable after February update
- Power Query M Question - Time in Pod/training
- M Formula for 'Text' Months from Week Values
- Power Query will not load all rows
- Filtering Salesforce data before loading it to the model
- Applying Cashflow Categories to transactions
- Working days
- Pass parameter from worsheet cell to Oracle
- Power Query updates for Excel 2016 Professional Plus
- Dynamic Filter in Power Query
- how to do nested ifs?...
- Permissions Error on Data Refresh
- Table.Addcolumn
- BASE_DATA_1 - QUERY_1A - QUERY_1B refresh
- How to import specific cells from several Excel files
- Power Query workbook save
- Splitting a text column with multiple entries from 1 to Many
- Custom Column with yesterday's date
- IF on a date field
- Power Query + Dynamic SQL WHERE IN
- Power Query - Users unable to download workbook due to data source error
- "IsNot" or "IsNotNull" Formulas
- Power Query Update Available (April 26, 2016)
- Help needed: Transforming this data into useful tabular format for analysis
- Update Source By Refresh Instead of Editing Query Detail
- Text.ToList - how to reverse this step
- How to replace a data source
- Keeping the file path whatever the current workbook file path is
- Rept function in Power Query?
- Referencing two queries
- Refreshing Pivot Tables after a PQ refresh
- Slow loading times
- Dates getting converted from European dd/mm/yyyy to US mm/dd/yyyy Format
- Appending queries without refreshing all of them...
- Projected Ending On Hand calculation
- Selecting a field
- 'Prompting' for parameter
- Create a new column with the number of occurences of a delimiter in another column
- Many to Many nightmare
- Power Query Update Available (as of Monday, May 23, 2016)
- Need help eliminating certain rows
- Extract the Month formatted as "MMM" from a date field (column)
- Dates in CSV Files
- Content of some lines in one line including "line break"
- SharePoint connection within PowerQuery/PowerPivot
- Multiple table in PowerPivot with PowerQuery
- Business Objects files and consistency
- VLOOKUP (as per Ken P)
- Total row on query
- Power Query Update Available (as of Tuesday, June 21 2016)
- Defer Updating of Pivot Tables until ALL Power Queries Refreshes have been completed
- Date data wont change to date format
- Excel 2016 June Update Get & Tranform issues
- Power Query: find which column contains my value and return column name
- Using a parameter table to filter dates column
- Subtotal of duplicate rows (one subtotal per duplicate, keeping all duplicate rows)
- Unstacking Columns in Power Query
- Reading files from a OneDrive for Business folder
- Heads Up: another silent release of the Power Query Add-In last week.
- How to add the file name (month name) to the contents file for monthly credit card..
- Remove rows below text
- Unpivoting Date Columns
- Power query - exchange server - possible to connect directly to one folder in mail
- Power Query Date.EndOfMonth Function Issue
- Add new row for multiple delimited values in a cell
- Power Query Update Available (as of Monday, July 25 2016)
- Calculate Multiple Columns by Another
- Problem Transitioning from Excel to Power BI ... Using Parameters
- Problem Transitioning from Excel to Power BI ... Using Parameters
- IF and AND - multiple conditions
- Merge with previous step
- Open External Workbooks
- Two tables, identical columns and rows, some blanks in cells, need to combine data
- FIFO Allocation with a fixed amount
- Questionnaire output
- Combine totals for two rows without grouping and losing columns.
- CSV file - number of columns import limited by parameter...any way around this?
- Querytable FillAdjacentFormulas
- Daily utilizaiton (occupancy) calculation
- Transform a Column
- Automate billing spread with P/Q
- Unpivoting Column and Format.Data error handling
- Recursion problem
- Power Query Update Available (as of Thursday, August 25, 2016)
- Ribbon info for Power Query to disable visibility using VBA
- Merge dynamic columns' name
- Selecting delimited data in multiple columns
- Dealing with bad data in columns - automating the removing duplicates
- Replace all NULLs with 0 in a table with multiple columns except in 1st column
- Substitute for Excel Function: TEXT(A2,"000000")
- Questionable application of PQ; transpose column headers into columns and append sets
- Multiple lines in IF statement
- Excel file in SharePoint folder as the data source for Power Query
- PowerQuery - Query SSAS Cube using List of Parameters
- Creating a "fulfilment table
- Use data from Table in Power Query
- Managing connections
- Parallel connections to DB
- Group after Appendig to tables
- Pick up MAX version number for each item
- Excel 365 Power Query - Moving columns/fields not working
- Row action missing in Query From Folder
- Use Power Query to Feed a Web Form
- Extracting first two rows from each of several folder files
- Splitting Columns by Numbers or Characters
- Power Query Update Available (as of Thursday, October 6, 2016)
- Data type when adding column
- Parameter to switch a query 'on' or 'off' without creating errors
- Powerquery will sometimes stop in middle of an API call
- Error Message When Grouping Data - "DataFormat.Error we couldn't convert to number"
- PowerQuery only brings in 1 column of data
- Apply a function to all columns in a query
- Formula: Is one of several Codes in one of several Fields?
- Converting B/M to number & % to decimal
- Date/Time import issue
- Logical test if first character of a string is a number
- Referring to columns by position rather than name
- Reading dbf files - error "Invalid SQL statement"
- Group By question
- Calculate Tenure in Power Query Customer Column
- Dynamic Group by (referencing cell value)
- Power Query Update Available (as of Thursday, October 27, 2016)
- Out of Memory error consistently happening with Power Query
- pivot/transpose/fill
- Parse for numbers only
- Expand number of columns after each merged workbook?
- Nested if's or creating a fnSWITCH function
- Power Query to extract data from a password protected website
- Combine Multiple Workbooks in Power Query - When File Structures are Different
- Need help in Power Query Date Requirement
- How to get the Last Refreshed date from a Workbook Query?
- Median
- Splitting a field and using part of the split result
- Run Power Query Routines in Sequence
- Power Query - Fill up -- conditional?
- Matching Text Columns
- Find Leading Spaces in Powerquery
- Find Leading Spaces in Powerquery
- Update Excel 2016 PQ ('Get and Transform') to Latest Version
- Powerquery transform text to date conversion error
- Transpose Columns with a twist
- Extract Cell Color with M
- Label in same column as data
- Power query - add time to date
- Power query - add time to date
- Expanding table scraped from web with more than 9 columns - cols are out of sync
- Out of stack space
- Refreshing Power Query / Power Pivot
- SAP BusinessObjects Universe with Optional Prompts
- Carriage Return Character in Power Query
- Expanding expanding data...!
- Text File into Table
- Using Power query to transform a profit & loss report into pivot table readable data
- Merging two CSV on job profitability where like jobs need to be added together...
- Power Query to only update records that have changed
- Power Query to combine file path with file name and add cell reference to extract inf
- Replacing null values in a column
- Urgent - Splitting text from numbers in a column, please help
- Merge Cell issue and Unpivot first row only
- Problem with "Remove Duplicates" in "Get & Transform" (Excel 2016)
- Error with refreshing query from shared file via Dropbox
- Expand column with a table in it containing variable numbers of columns
- sql select in (), with arguments from xls sheet
- Duplicate data in columns
- Change the 4 digit year in date to 2 digit
- Power Query specifications and limits while working with Text files
- Keep order of columns when expanding
- Power Query conditional join between 2 tables
- Datedif Date to Words Possible in Power Query
- Making Column Count dynamic (not the names but the number of columns)
- Query parameter always using current value instead of query result?
- Import Excel - force all columns as text
- Match parts of strings in a lookup table and return another column
- Removing text from column referenced on list
- Power Query Running Total with Multiple Criteria
- Power Query Running Total with Multiple Criteria
- Three sets of columns to 1 set...
- Group by solution
- PowerQuery IsDate function
- Date Parameters
- Cartesian Joins by rows with the same ID
- Number of tables in Navigator limited to 10,000. Edit Query does not pass values back
- Receive error when attempting to update
- Filter and transpose data from rows to column
- Power Query Help
- Power Query with dependent queries
- Table Equations adjacent to Power Query result
- Query Editor - Taking a LONG time to refresh as I work on query steps
- Change Data Type on all but 1st column
- Import from several CSVs to separate sheets in a workbook
- How to save a sorted query to the data model (for performance reasons in Power Pivot)
- Flattening tree records
- How to convert function parameter from text to Table Column reference
- Refresh Queries at different times
- Query Refresh problem
- Power Query Header Format Change on Refresh
- Pivot Not Refreshing Until Slicer is Changed
- Please rebuild this data combination
- How many workbooks can Power Query handle?
- Convert Data from "top to bottom" to "left to right" including some adding values
- Data Extraction & Creating relationships in excel file
- Change value based on value of another field
- Keep the most recent assigned salesperson
- Power Query - Add Columns Conditional
- Append Tables or use Multiple Tables
- merge non-contiguous and contiguous range periods with the same attribute
- Parameterizing a column name
- Create Daily Periodic Interest Rate Index from Monthly Summary
- Power Query refresh and Solver add_in
- Rearranging overhead costs in financial statement using power query - possible?
- Help. Ranges date filter with PQ
- Split Column by Delimiter but Retain Text Format
- How to exclude certain sub-folders when using Get Data From Folder option
- Remove Null Rows
- Excel 2010 crashing since installing Mar 17 power query update
- Tables not showing up in Query-Editor
- Refreshing a query from another query
- Dynamic Cols select
- Transpose Duplicate Rows into Repeated Columns during Query Merge
- How to edit source data after you've created your data model and measures in pwrpivot
- LEFT + SEARCH Function Help
- Time problem
- Not Able to Unpivot Nested Headers and Multiple Spreadsheets
- First column missing in query results
- How to handle #n/a
- Non existent error in Append query
- Search (Text Contain) multiple values
- Overwrite columns
- Working with Column Headers in Power Query
- Using PowerQuery as a self-help interface to database applications
- Pivoting data by month column and summing the resulting months by row...problems
- Import file from folder; file & data is duplicating
- Pivot multiple columns +
- Refresh power query while workbook protected
- Table.TransformColumns with reference to another column?
- Power Query and Amazon Sales Data