Questions tagged [m]
The M Modelling Language was a component of Microsoft's "Oslo" project, later known as SQL Server Modeling CTP. The project was canceled in late 2010 but the language was updated and incorporated into Power Query, Power BI, and Excel.
1,351
questions
1
vote
0
answers
34
views
Ignoring error in Table.ExpandTableColumn or auto-replace with null
I am loading 100s of XML files from a folder and Power Query has created a function from the first file I had loaded. The problem is not all the XML files have a similar structure. Some have nodes ...
0
votes
0
answers
18
views
problem with import text in pdf by power query (right to left language)
if i convert ".pdf" to text & use get data from ".txt" or ".csv" file & set file origin on "1256:Arabic (windows)", then i have a correct text in PQ.
...
0
votes
0
answers
32
views
Power Query Pagination when the cursor reference for the next page is given as part of the initial JSON Response
I know this has been answered several times with a loop and a variable to hold page size and count, but the API I'm trying to use doesn't have those parameters.
In my API Call:
https://someserver....
1
vote
1
answer
20
views
Power Query - Add column with path for each file
I have two queries (working) hat do exactly what I want:
they scan a folder for DBF files with a particular name
convert each one into a table
combine the tables into one long table
I want to add a ...
0
votes
1
answer
44
views
Use Power Query to consolidate rows (like Pivot Table, but maybe something else)
(Very simplified) I have data like this that I get after a complex series of steps in Power Query.
Previously, I used a Macro to create a Pivot table like so:
But I was hoping to get away from that. ...
1
vote
2
answers
39
views
Extract JSON Array to same Row using Excel Power Query
I have the following JSON
{
"Data": {
"totalExecutionTime": "00:00:00.5544916",
"totalCount": "33414",
"Items": [...
0
votes
3
answers
51
views
Create a column that counts all "Y" in all other columns for each row in Power BI
I am working in Power BI and have dataset with columns containing "Y", "N", or "NA". There are over 100 columns so I am trying not to create an if statement for every ...
1
vote
1
answer
29
views
Partial Power Query transposition so that captions remain
Novice power query user here. I would greatly appreciate if someone could help me with the following problem. I'm tasked with modifying an excel template that is roughly of that format:
City
Borough
...
1
vote
2
answers
40
views
Identifying the max in a group using PowerQuery
I have a table:
trip_id
stop_sequence
Y1
1
Y1
2
Y1
3
Y1
4
Y1
5
Y2
1
Y2
2
Y2
3
Y2
4
I want to add a custom column that has a value of TRUE for the record which has the highest value of ...
1
vote
1
answer
55
views
Microsoft Graph API - Pagination to get more than 500 members
I'm trying to extract the users of an azure group, I use first a function ''GetToken'' to get select the group from Azure and the token, then I use this function to get the users:
let
Source = (...
0
votes
1
answer
41
views
Calculating average for each category and for multiple columns
I have a table there rows represent time period. Columns represent different locations "kiosks".
And values represent sales in each kiosk on different times.
Data example:
Date and time
...
2
votes
2
answers
35
views
How to do aggregations while preserving the same number of rows?
My input table is the two orange columns and I'm trying to create the three blue ones :
The column ND_ID is the index of each group of ids
The column CNT_ID is the length of each group of ids
The ...
2
votes
1
answer
55
views
Does unchecking enable load have impact on refresh?
I'm looking at an example where the enable load is unchecked. This automatically grays out the include in report refresh option.
So it neither loads into the model nor does it refresh this table.
...
1
vote
3
answers
79
views
Unstacking table with multiple columns in Power Query
I am trying to convert this table:
ID rating cntry Index
Albert 603 pl 0
Peter 912 at 1
Peter 907 at 2
Albert 608 pl 3
Franz 833 pl ...
2
votes
2
answers
86
views
How do I remove quotation marks from characters strings in Power BI?
I have unstructured data with quotation marks I'd like to remove using Power Query. Here's an example:
Have:
chrome has been “processing” for 8 mins now.
Want:
chrome has been processing for 8 mins ...