Questions tagged [power-query]
For questions related to the Microsoft Power Query add-in for Excel. Use this tag together with [microsoft-excel] and, if relevant to your issue, the tag for whatever kind of data source you are querying, for example [microsoft-access] or [mysql].
247
questions
0
votes
2
answers
52
views
How can I associate, group, or connect rows in Excel?
This might be a niche question so I'll try to generalize it as much as possible.
Upon extracting data from a folder with PDF files and after some data cleaning, I have the following in PowerQuery:
...
0
votes
0
answers
20
views
Excel PowerQuery locking source file for Git
I am using PowerQuery in Excel to load a CSV config file.
= Csv.Document(File.Contents("myFile.csv"),[Delimiter=",", Columns=4, Encoding=1252, QuoteStyle=QuoteStyle.None])
This ...
0
votes
0
answers
69
views
Multiple Slicers with Multiple Selection in each with AND condition in Power Bi
I am working on a model that filters items based on the criteria given in the slicers. In this I want to filter the item through three slicers
Hierarchy Slicer
Attribute Slicer
Attribute Value Slicer
...
1
vote
1
answer
45
views
How do I actually automate with PowerQuery?
I had been under the impression that one of the key features of Excel's PowerQuery add-in was the ability to automate/reuse repetitive processes. I thought this would be achieved extracting the steps, ...
0
votes
0
answers
79
views
This data set is too large for grid
My current project involves a table with Excel formulas that reference a csv file that is constantly updating. However, this csv has recently grown too large to fully display as a connection. ...
2
votes
1
answer
432
views
Locate and/or reinstall link to MS Query in Excel 365
I have a small data querying and analysis team that uses Microsoft Query to pull data from an ODBC connection. We are running Microsoft 365 and tapping into data sources inside Excel. The ODBC data ...
0
votes
1
answer
39
views
A query on Power Query: Faster way to transfer data from one file to the other
I am currently consolidating financial statements for 2023 with comparative data for 2022 across multiple agencies.
Now, I have to do the following tasks:
A) Make a way so that the previous year's ...
0
votes
2
answers
161
views
Can an Excel Filter function base its include on a whole row?
I have a Table from which I pull a list of unique values, then I want to pull all their keys and merge them using textjoin. But the Filter function the criteria to be compared against a single value, ...
0
votes
0
answers
31
views
Connecting To Salesforce Single Sign On Via Power Query In Excel (Error
Just wondering has anyone encountered an issue where when trying to authenticate a user via single sign on with the Salesforce Object Connector, they get the error AADSTS50178?
It tries to sign the ...
0
votes
0
answers
24
views
Importing CSV into Excel via Data -> From Text/CSV: Can I automatically apply the Power Query column formats?
Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit
I have an external program that creates CSVs. Some of the columns have eg. $ or %. The import query is smart ...
0
votes
0
answers
48
views
How to have the same values for duplicated items in Power Query?
I've come across a scenario where I have duplicate values in the column ID without letters I'm trying to ensure that these duplicated IDs also have the same values in the Stock Unit, Type and Has ...
0
votes
1
answer
46
views
Custom columns in Power Query vs additional columns in Excel source
I have a report in Power BI that uses data from an Excel file. Is it better to have a very slim Excel table with values only and add all (possible) calculations via custom columns in Power Query or ...
0
votes
1
answer
169
views
How to open nested tables from power query, in new sheets?
In excel, I have a power query which loads a table with nested tables. In the query editor window, I can click the Table and drill down which is great.
Problem is, when I do save and close, and return ...
0
votes
0
answers
83
views
Power Query SQL bring in cell contents for the where statement
I am trying to build a flexible sql where statement so that my power query can pull the exact data the user specifies. I have an excel worksheet with about 18 cells that the user populates. I use ...
1
vote
1
answer
24
views
reformatting people-planning table in powerquery
I have a table:
Date
personA
personB
personC
1/1/24
x
H
2/1/24
x
Y
3/1/24
A
x
4/1/24
Y
x
5/1/24
x
x
Above the table I have a table with a title "Person" and 1 cell with a dropdown ...