6,571 questions
0
votes
0
answers
53
views
How to show value from one table by slicers referencing another table?
I have a Power BI report with two tables in it. Table_1 looks like this:
Tariff_name
ID
Tariff_1
ID1
Tariff_2
ID2
Tariff_3
ID3
Table_2 looks like this:
Tariff_name
ID
Tariff_33
ID2
Tariff_44
ID1
...
- 1
0
votes
1
answer
171
views
Why am I getting an Out of Memory error with this specific VBA code?
I have Power Query table in an Excel spreadsheet that filters a different table for a specific Index number using a List Box of Client Names.
The first table has 3 columns:
Index
Attribute
Value
1
...
0
votes
1
answer
52
views
Custom Column returns [Table] instead of value most of the time
I’m facing a strange and very frustrating behavior in Power Query (Power BI Desktop).
When I create a Custom Column, instead of returning a single value, the column returns a Table on each row ([Table]...
0
votes
1
answer
60
views
Power Query M Add File Name as Column Values
I am trying to combine a large amount of files that are essentially text files with an odd file extension (.pri). Each file is named by date (03312022.pri), but the date of the file is not included in ...
1
vote
1
answer
49
views
Creating a Basket Analysis that Customers who buy X also LATER bought Y
I am trying to make a visual in Power BI that shows me what people order second, if they order x product first. Very similar to a basket analysis but I don't want to know what was in the same cart as ...
-3
votes
0
answers
39
views
Power BI - Dynamics - Issues Filtering Query in GetData
Im having an issue where I'm pulling data from Dataverse. The query itself always returns as too complex. I cannot transform the data at the GetData stage because its too complex and I cannot preview. ...
- 1
0
votes
4
answers
148
views
Using PowerQuery to extract particular record from a column to another column
I'm trying to extract particular record from a body column and update into separate columns using PowerQuery.
Scenario: I'm fetching records from Microsoft Exchange into an Excel file, separated into ...
- 149
-1
votes
0
answers
84
views
Issue when using Table.Group with List.Sum and Number.From
Why does this code fail?
Acknowledge that the "Amounts" column is intentionally of type text. I can use List.Sum and Number.From in conjunction with say Table.AddColumn, and all works out as ...
- 55
0
votes
0
answers
73
views
Convert a single column to multiple table columns and create null values
I have a table in power BI that looks like this: power query source table
I'm trying to change the "Series Name" column into individual separate new columns based on the values in "...
0
votes
1
answer
45
views
Power Query Concatenate and If statement
I want to add a custom column to concatenate several columns with some if statements. I am getting a "Token 'else' expected error message. Can you please tell me what I forgot or did wrong? Power ...
0
votes
1
answer
78
views
In powerquery I need to control if a merge happens based on a condition
I need to accomplish two things.
I am trying to generate a folder tree. I have to find a target folder. Starting at the root folder, I am merging a list of objects based on OBJECT_ID = PARENT_ID. This ...
1
vote
2
answers
56
views
In Excel Power Query, can I return a specific table if the data is empty, but return the data if it exists?
I'm using Excel to create a fire weather product for a specific National Forest. One of the tables reported includes National Fire Danger Rating System (NFDRS) indices and weather observations from ...
0
votes
3
answers
139
views
Power Query Unqiue Row Formatting With Sum
Trying to figure out if this is even possible as LLMs have failed to answer this question.
I have a report from our companie's ERP that exports as a CSV. This is a basic inventory report that looks ...
- 47
-4
votes
1
answer
52
views
Unable to recreate an Excel formula in Power Query [closed]
I am trying to recreate this Excel formula in Power Query. I have very little idea what I am doing so I need some help.
=\[@\[DOC ID\]\] &"-"&COUNTIF(\[DOC ID\],\[@\[DOC ID\]\])
I ...
0
votes
1
answer
63
views
Fabric Dataflow Gen2 not showing all columns of an excel sheet because of the dimension property in the xml
I am working on a new Dataflow Gen 2 to import Excel files from SharePoint.
The problem I am running into is our vendor, who is supplying the files, is not properly setting the worksheet dimension ...
- 1,011
1
vote
1
answer
103
views
Power Query - Error Convert Null to Number at Merge
I have a tool I created that simplifies and combines some Sharepoint files with basic tables with a SQL database query and I've been using it for about a year. Suddenly, it's not working and throwing ...
- 23
0
votes
0
answers
49
views
How do I create a dynamic title with a multi-select slicer to display when single, multi, and all selected?
I am attempting to create a dynamic title that will return the category when 1 item is selected, return multiple options separated by a comma when they're selected, and return "ALL" when ...
1
vote
2
answers
135
views
Add an Index for Duplicate Values using Power Query
I have a dataset that has duplicate Invoice Number values.
I need help generating an index column ("Occurrences") to count the number of occurrences of the "InvoiceNo".
Any ...
- 13
1
vote
1
answer
70
views
Changing Data Query Source File Property
I am attempting to change the Source property of a query in an Excel file via PowerShell. I have found the Connections properties, but am unable to locate the specific property that contains the ...
- 2,088
0
votes
2
answers
69
views
How create a dynamic cumulative sum in power query
I want to create a sum in power query (Measure C below) returns the cumulative sum of Measure A + Measure B and is limited to zero and which resets at the beginning of each Period as shown in the ...
1
vote
1
answer
93
views
Excel Power Query - Dynamically change date in source url from cell value
This is a fairly simple question but I am unable to find any relevant documentation for it.
Having created a power query in Excel how can I alter the date in the url string from user input on the ...
- 115
1
vote
1
answer
48
views
Filter date using bookmarks PowerBI
I would like to change the date daily by clicking on the arrow.
Selected date should be changed daily by clicking on the arrows. Is this even possible ? many thanks in advance.
I need something more ...
- 3,031
0
votes
1
answer
124
views
VBA PowerQuery Directory
I am using VBA to try and hopefully automate my PowerQuery needs.
I've recorded a macro from the import data from PDF in the data tab.
I have then tried creating a user definable source path within ...
- 13
0
votes
2
answers
79
views
Create a calculated column with if statement power query
I have a data as below. I need to create a calculated column in power query. Full name can be consisted of name, last name, middle name and, 2 letters (which should be added in the lastname). Many ...
- 3,031
3
votes
3
answers
246
views
Stack Integer Sequences from a List
Intro
I wrote an answer to Expand records for each month between two dates. A part of my solution was to stack integer sequences from a column of integers. There were only 4 integers in the column, ...
- 56.8k
1
vote
1
answer
54
views
Non-hardcoded AddColumn
I'm trying to write a PowerQuery to enable Users to compare to Data Sources (with an unknown number of fields), determined at runtime by the user filling a table.
Of course if the fields are known I ...
- 75
0
votes
1
answer
58
views
How can I aggregate all columns with a 'number' type in power query
I'm trying to use power query to aggregate some invoicing columns by project number in power query.
I'm currently using a group by function which looks at the project number and then aggregates each ...
0
votes
1
answer
47
views
Using function parameter in field-access-expression
I am trying to convert some hard coded PowerQuery into a function so it can be reused, but am having an issue with the field-access-expression, as it is using the parameter's name rather than value.
...
- 75
0
votes
1
answer
87
views
Replace column value based on another column
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "pm plus",
each pmplus[Qualifies for]{List.PositionOf(pmplus[Combined Criteria],[combined criteria])}),
#"...
- 3,208
1
vote
2
answers
139
views
Power Query – Cancel last N positives based on N negatives
I have a table in Power Query like this:
PO - Purchase Order
SID - Ship ID
QTY - Quantity
PO
SID
QTY
1001
A001
2000
1001
A001
2000
1001
A001
-2000 (This line cancel the previous one)
1002
A002
3000
...
-2
votes
1
answer
60
views
How do I pivot distinct values in Excel (preferably PivotTable fields editor)? [closed]
I have a table layout with different number of text values for each id column. Now, I'd like to pivot them, so that each id gets a single row and each text value is put into a different column of the ...
- 3,262
1
vote
2
answers
132
views
Count consecutive rows in Power BI that have a value. Get start date and max grade from that group
I have a table with the following data:
record_id
visit_date
int_date
month
hb_ae
wbc_ae
anc_ae
plt_ae
ast_ae
alt_ae
arc_hb_ae
sched
10
9/9/2015
7/8/2015
1
2
Sched
10
10/9/2015
7/8/2015
2
2
Sched
10
...
- 397
0
votes
1
answer
133
views
How do I force refresh a PowerQuery with VBA?
I'm trying to automate a workflow with a macro, but I can't seem to get the PowerQuery table to update with VBA.
Sub DepartmentalBudgetsMonthlyUpdate()
Dim wb As Workbook
Dim fName As String
...
1
vote
2
answers
144
views
VBA macro - problem with Application.ScreenUpdating
I have a problem with ScreenUpdating which I want to disabled.
I have a power query connection which is refreshing. I connect excel files from folder in power query , after that I disabled background ...
- 11
2
votes
3
answers
145
views
Use the same Power Query script (M Script) on different files
I have a file which contains an M Script executed on the connected data. However, the file where the data resists (source) changes every 3 months. Also the filename changes so I have to change the ...
- 665
0
votes
0
answers
113
views
Excel VBA: WorkbookConnection.Refresh crashes on Windows but works on Mac - Power Query issue
Problem:
My Excel VBA application crashes during Power Query connection refresh. The exact same code and file work perfectly on Mac but show inconsistent behavior across Windows machines with similar ...
- 1
3
votes
1
answer
106
views
Group data with dynamic columns
I am working on a system to compare data of QA audits. The data sources contain a dynamic number of columns (based on QA agents) and a dynamic number of rows (based on the QA format).
The system I am ...
- 31
3
votes
2
answers
141
views
How to join two tables when one table has filters to applied to the second one?
I have these two tables:
+-------------------+ +-------------------+
| TAB1 | | TAB2 |
+---------+---------+ +---------+---------+
| PRODUCT | ACCOUNT | | GR | ...
- 31
2
votes
1
answer
106
views
Move entire rows when PowerQuery data change [closed]
I'm working on a file with two different tables on two different Queries, with this structure:
Table 1
GROUP MEMBER
ID
GROUP
SCORE 1
SCORE 2
SCORE 3
Member 1
01
A1
1
1
4
Member 2
02
A1
3
3
5
Member 3
...
- 57
2
votes
1
answer
58
views
Error with MS Excel power Query ODBC Context
I have a parameter coming in from the excel table that is formulated as date time.
7/28/2025 12:00:00 AM name BeginDate
I am trying to filter the source data which has a field called TransDate before ...
- 21
0
votes
0
answers
71
views
Power BI Online - Cannot Set up Automatic Refresh for REST API Source Without Gateway
I have a Power BI report where I connected to data from ArcGIS Online using a public REST API endpoint. Because the REST API only returns 1,000 records per request, I wrote an M query (Power Query) ...
- 29
1
vote
1
answer
100
views
What is a more efficient way to take results of a query in a tabular model and use that to query additional models?
I need to filter two separate tabular models and return a table of summarized results from each, using values retrieved from a third semantic model for calculate context. The process creates a data-...
- 470
-1
votes
1
answer
102
views
How to add same index column for every 10 rows [closed]
My csv file have one column with multiple rows.
I read that file in power bi desktop and try to display as paginated report .
The design I want to display is I like to show every 10 record as one page ...
- 4,588
2
votes
1
answer
60
views
Does Power Query Choose columns prevent columns added later from being displayed/recommended way to do this
I have a situation where I have a Power Query that connects to a database, and I only want to display certain columns in my spreadsheet. I know this can easily be done with Remove Columns. However, ...
- 514
0
votes
1
answer
55
views
Data transformation in PowerBI for a column where data source is Azure Synapse Analytics SQL
I got my data in PowerBI by connecting to Azure Synapse, where I need to transform a column in PowerBI where the column (text) contains list of numeric values eg. [0,1.0,0.05] in a single row needs to ...
- 1
0
votes
2
answers
80
views
Text to Duration in Excel Power Query
Trying to covert a text string to duration in a column. problem is I have some values that are mm:ss.zzz and others that are just ss.zzz I know it needs to be hh:mm:ss.zzz but not sure how to add ...
0
votes
0
answers
99
views
Paginated report (power bi report builder) take along time to fetch data
I created a power bi report builder
I used a sample query to get data from one table
EVALUATE SUMMARIZECOLUMNS (
'InventRepriceJourTransEntity'[ItemId],
'InventRepriceJourTransEntity'[...
0
votes
1
answer
107
views
Incorrect text and emoji encoding when importing Meta (Instagram) chat JSON
I'm trying to learn how to use Power BI, and I thought it would be fun to test my skills by creating some statistics based on my chats with friends. For example, I want to identify the first message ...
1
vote
1
answer
137
views
What's the difference between "Unpivot Columns" and "Unpivot Only Selected Columns" in Power Query?
When I select multiple rows and right click in Microsoft Power Query, (in Excel 2016), I see two similar options for unpivoting: "Unpivot Columns" and "Unpivot Only Selected Columns&...
- 27.8k
0
votes
2
answers
65
views
Creating data model in Power Query to map lists of fields to nested subset of JSON data
I'm attempting to create a Power Query data model with some unpleasantly-formatted JSON data, and would like to present it more logically to its consumers.
This is a heavily simplified abstraction of ...
- 3,648