Tag: power-query

7 Loading a json file into Power Query 2015-09-23T18:46:06.290

3 Transform multiple columns in Excel table into multiple rows 2016-01-06T23:07:18.047

3 Excel - Using SQL command on Power Query data 2017-11-03T13:00:20.620

3 Excel Power Query date format messup 2018-03-15T09:32:16.163

3 How do I get a cross-join with power query to "remember" values associated with it? 2018-08-15T17:37:27.843

2 List an AD Group Membership using Power Query / Data Explorer 2013-07-26T14:52:06.543

2 How to set a cell value using the result of a parameterized SQL query using Power Query? 2018-01-23T12:05:52.997

2 How to call Power Query M function from external Workbook? 2018-04-29T15:03:42.953

2 Does Microsoft Power BI have file size limitations for functionality like Excel Power Query does? 2019-08-22T13:32:22.720

2 Excel Power Query 2019-10-29T14:04:02.870

2 Excel sheet with query to local file does not work on other machine 2020-02-19T15:43:08.257

1 Connect to PostgreSQL database from Excel 2013 Power Query with Npgsql 2015-08-03T19:38:03.667

1 Power Query Conditional Dynamic Filter 2015-09-16T19:15:13.157

1 'From azure' button missing on Power Query ribbon 2015-09-22T15:20:34.437

1 Parameterizing IN clause in PowerQuery SQL query 2016-03-29T20:18:29.880

1 Excel 2016 list of options for connection to DB has suddenly reduced, (MySQL, PostgreSQL) 2016-04-07T06:34:24.973

1 Outer join with union in Excel 2010 using Power Query 2016-04-23T21:16:37.050

1 Running Parameterized Stored Proc From Power Query 2016-05-24T19:20:50.460

1 Excel Power Query EndOfWeek 2016-06-27T16:03:46.130

1 Excel - power query (or anything else) - join on partial match between fields? 2016-08-18T19:52:41.810

1 Use parameters in Power Query 2017-01-27T10:20:15.697

1 Power Query: Delete three character substring based on 2 character substring match 2017-04-13T17:28:21.627

1 Use Excel to format denormalized table as report with summary headers and detail rows 2017-07-10T17:21:37.983

1 Doing calculation in PowerPivot (Excel 2010) based on two tables 2018-02-25T18:32:19.647

1 Duplicating Steps in PowerQuery 2018-05-25T22:10:43.410

1 Trying to export single column's data from large CSV file 2018-08-01T21:36:22.970

1 Updating a Power Query automatically when adding rows 2018-08-13T15:49:01.140

1 Retain cell formatting after data refresh in Power Query Excel 2018-12-17T14:27:30.197

1 Excel PowerQuery cannot find SharePoint files after a certain date 2018-12-20T12:46:55.220

1 Excel spreadsheet/workbook data connections: Two way communication with applied filter? 2018-12-27T22:19:15.967

1 Oracle.DataAccess.Client and .NET Framework errors in Microsoft Excel 2019-04-17T15:07:41.107

1 Excel – Set cell values in a column based on another cell value in intervals 2019-04-29T18:00:37.867

1 Power Query and Excel don't agree on sorting? 2019-06-13T08:49:20.077

1 How to apply Conditional Formatting based on previous cell value in Power BI? 2019-06-27T15:48:48.350

0 Creating pivot tables from multiple worksheets with power query, how to copy query for 20 workbooks? 2013-10-30T16:20:01.360

0 PowerQuery to parse fixed width csv 2015-03-11T10:50:32.747

0 Dynamic field names in Excel queries 2015-04-24T20:11:58.953

0 Excel Power Query joining all text files together, need them on separate rows Basic 2015-07-19T00:55:00.233

0 Fetch Google Sheets data with Excel Power Query 2015-08-27T12:40:36.400

0 Power Query Connect to Essbase Server 2015-10-06T14:24:01.033

0 Variables from Multiple columns lookup to insert new column in Power Query or Power Pivot 2015-10-29T13:06:38.090

0 How to share Power Query queries 2015-12-08T06:15:26.223

0 Loading data to power pivot via power query vs. directly to power pivot 2015-12-15T02:36:55.390

0 Add custom category type column to an Excel 2016 Power Query 2016-01-03T06:49:39.723

0 Unable to remove columns based on data-type using Power Query 2016-02-02T23:36:11.373

0 Power View Not Working Excel 2016 2016-04-21T20:49:34.573

0 Excel power query slow 2016-08-01T19:49:59.480

0 Excel Power Query causing scroll wheel issues 2016-08-15T14:53:37.960

0 Reducing the amount of data pulled in an Excel external data source query? 2016-09-07T15:50:19.687

0 Power Query - How can I convert these columns into rows? 2016-10-17T15:24:44.667

0 File Path button missing in source step after upgrading Power Query 2016-12-09T15:42:03.253

0 How to change Data Source in Power Query for Pivot Data? (Browse Button missing) 2016-12-20T09:24:39.910

0 Loading a json key-value map into Power Query 2017-01-06T12:08:21.710

0 Excel Power Query Error - Expression.Error: The argument value isn't valid 2017-06-22T16:22:09.333

0 How to merge multiple tables (5) with a common column 2017-07-04T06:58:36.523

0 Power Query - how to connect to sharepoint list using VBA 2017-12-19T08:06:36.773

0 Using Excel 2016 Power Query to Perform Conditional Inner Join 2017-12-31T06:53:23.070

0 Cannot connect to a shared OneDrive (Personal) file through Power Query 2018-01-21T13:12:13.403

0 Pick top 3 values and sum them 2018-03-01T21:30:20.080

0 Use a Cell Value for a Paramater Value using in Power Query 2018-03-14T13:44:09.853

0 "pivoting" two tables together to generate a new table 2018-07-20T19:05:45.730

0 Excel how to join separate tables 2018-08-24T04:01:59.140

0 Custom Column with Origin of Table 2018-08-28T23:02:47.163

0 Clearing all data and authentication information from Excel Power Query Connections 2018-09-01T01:49:43.717

0 Combine 2 tables on multiple key values - EXCEL 2018-09-06T12:32:30.320

0 Excel - Is it possible to make a drag and drop function to save files directly into a folder? 2018-09-07T11:33:54.460

0 How to use Power Query to create pivot tables with non-numerical values 2018-09-13T18:45:50.857

0 Power Query - Value.Divide(Value.Add( )) returns all "null" results 2018-10-23T11:27:34.870

0 Excel 2016: Query from folder not combining csv's by header row 2018-10-30T23:18:54.913

0 PowerQuery ODBC connection revokes password: due to auto-refresh? 2018-11-07T04:03:33.297

0 Power Query with Additional Column 2018-11-14T14:45:01.180

0 Automatically update a Power Query after data was changed in source(another sheet in same workbook) 2018-12-09T16:43:03.027

0 Grouping Date/Time by hour in pivot table not working as expected 2018-12-14T17:11:34.387

0 Excel Transpose Certain JSON Fields 2018-12-21T04:31:12.327

0 Display a countdown timer for web query refresh 2018-12-31T04:11:54.053

0 Excel group transposed columns by date 2019-01-02T21:29:08.447

0 Power Query; Calculating when a certain value in numerical order is missing and creating an additional row 2019-01-30T19:10:17.913

0 Excel: how to import identically formatted CSV files 2019-02-06T21:34:06.780

0 Power query - turning number strings into numbers while preserving text 2019-02-11T18:34:18.100

0 Copy But Unable to Paste within a Excel Worksheet 2019-02-13T22:17:45.060

0 OData Feed / Power Query in Excel 2016 Not Retrieving All / Duplicating Some Records 2019-02-14T18:07:33.563

0 Load many csv files at once in Power BI 2019-03-22T18:13:17.253

0 How do I compare two columns for matching and non matching values and get it in the format that I want? 2019-03-25T06:23:52.417

0 How can I use Excel's Power Query From Web option to extract news headlines from various sites, and keep the data in real-time? 2019-04-09T06:54:01.293

0 Power Query - Appended Queries pulling from same folder - Need only 1 query to run on new files 2019-04-11T18:33:08.580

0 Power query pivot column with multiple records 2019-04-22T14:08:56.940

0 Data Slicers not working properly with Excel 2016 2019-05-08T09:41:58.217

0 Excel Power Queries fail when refreshed via vba 2019-05-13T10:42:10.627

0 170+ columns, count number of rows with repeating (duplicate) data 2019-05-27T05:00:49.290

0 How to create a histogram with 2 legends based on dates 2019-06-04T08:50:01.410

0 Excel pivot table - combining data from three columns. Power query? 2019-06-10T08:23:13.687

0 Excel Power Query: [DataSource.NotFound] File or Folder: We couldn't find the folder 2019-06-18T20:36:09.897

0 Add missing values to power query result set based on criteria 2019-06-19T08:19:48.720

0 Background Refresh Not Refreshing 2019-07-05T12:24:02.893

0 Power Query Not Showing second decimal if zero 2019-07-05T18:06:13.243

0 Excel Power Query Load Times - Why do dependent queries reload CSV file data? 2019-07-25T22:51:39.027

0 MS Excel 365 : Comma Delimited data to rows for multiple columns 2019-08-08T10:31:26.007

0 How to make a DAX measure NOT to re-calculate on aggregated levels? 2019-08-20T19:57:04.150

0 Subindexing and Marginal Differencing in Power Query (Excel) 2019-09-10T14:26:12.120