6,572 questions
0
votes
0
answers
101
views
Why am I getting an Out of Memory error with this specific VBA code?
Hi I am relatively new to coding VBA and I am getting an out of memory error that I wasn't previously getting in the 8ish months I have been using this code. I hope someone can help me diagnose how to ...
0
votes
1
answer
52
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 ...
-3
votes
0
answers
35
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
0
answers
39
views
Query loading a lot of data from a small file [closed]
I have a power bi report with four connections to four excel files.
One of the files is around 1500 rows and 800 KB of memory.
The query i am interested in appends three queries, each one of those ...
- 9
0
votes
0
answers
70
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
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 ...
0
votes
3
answers
138
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
0
votes
1
answer
61
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
0
votes
0
answers
44
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
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
1
vote
1
answer
86
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
0
votes
1
answer
118
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
3
votes
3
answers
244
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
0
votes
1
answer
57
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
80
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
-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
0
votes
1
answer
132
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
...
2
votes
3
answers
140
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
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
2
votes
1
answer
103
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
0
votes
0
answers
70
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
votes
1
answer
100
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
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
0
answers
88
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'[...
1
vote
1
answer
131
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