Articles about power query

Merging Across Rows Using Ablebits

Learn how to merge rows across multiple columns in Excel using Ablebits Data Prep add-in in Power Query.

How to Load DOCX File in Excel using Power Query

Learn how to load a DOCX file into Excel using Power Query, even if Excel can't load DOCX files manually. This guide shows you how to save the DOCX file as a text file, place the new text file in the desired location, and use Power Query to load the text file into Excel.

Controlling Output Power in Power Query: Handling Empty Queries

Learn how to control output power in Power Query by handling empty queries. This tutorial will guide you through the process of managing empty tables and improving the performance of your data transformation tasks in Microsoft Excel using Power Query.

Using Power Query Excel to Pull SharePoint Documents: Library Managed Metadata

Learn how to use Power Query in Excel to connect to SharePoint libraries and pull documents using managed metadata. This tutorial covers the basics of Power Query, displaying PQ data in Excel, and clicking through to the SharePoint library.

Fixing Power Query Expression Error: Not Applicable Field Access Type List

Learn how to fix the Power Query Expression error 'Not Applicable Field Access Type List' when trying to add a running total column to a table combining transaction records from several different bank accounts. Follow these steps to resolve the issue.

Unlocking Hidden Information in PDF Documents with Power Query

Learn how to access certain PDF documents' hidden information using Power Query, either in Excel or Power BI Desktop. This tutorial will guide you through the process of obtaining and utilizing the data that is not typically visible using a PDF viewer.

connecting-salesforce-single-sign-on-via-power-query-excel-error-aadsts50178

This article provides a solution for users who encounter the error AADSTS50178 when trying to authenticate a user via the Salesforce Object Connector in Power Query Excel while setting up Single Sign-On.

Speed Up Data Transfer in Power Query: A Faster Way to Consolidate Financial Statements for 2023

In this tech support article, we will show you a faster way to transfer data using Power Query, making it easier to consolidate financial statements for 2023 from multiple agencies. By following our step-by-step guide, you can significantly reduce the time it takes to import and transform data, which will help improve productivity and efficiency.

Importing Truncated Data from Salesforce via Excel in Power Query: Workarounds for 257 Character Limit

When importing data from Salesforce into Excel using Power Query, text fields with a maximum length of 257 characters may be truncated. This article provides workarounds to resolve this issue and ensure complete data import.

Excel: Connecting and Grouping Associates with Power Query

Learn how to connect and group associates in Excel using Power Query. This tutorial covers data cleaning and Power Query scripts for merging PDF files and preparing data for analysis.

Automating Power Query: A Game Changer for Excel Users

Excel's Power Query add-in offers the ability to automate and reuse repetitive processes, making data preparation more efficient. Learn how to get started.

Matching One Column Another: Power Plant Coordinates in Excel

Learn how to match one column against another in Excel using various methods, including VBA and Power Query, to merge data from different worksheets or tables based on common coordinates, states, or cities of power plants.

Power BI Uses Excel File: Slim Down Table Values with Custom Columns in Power Query

Learn how to use custom columns in Power Query to optimize your Excel data for use in Power BI. This tutorial provides step-by-step instructions for adding calculations to your Excel table, making it easier to analyze and visualize your data in Power BI.