Stack Overflow
Stack Overflow

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.

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.

See also:

823 questions
46
votes
4 answers

What's the difference between DAX and Power Query (or M)?

I have been working on Power BI for a while now and I often get confused when I browse through help topics of it. They often refer to the functions and formulas being used as DAX functions or Power Query, but I am unable to tell the difference…
user2724541
43
votes
1 answer

How do I comment in Power Query M?

Is there a way to comment M code / comment out lines or blocks of code?
Chris
  • 1,139
  • 1
  • 10
  • 19
27
votes
1 answer

How can I reference a cell's value in PowerQuery

I'm having multiple PowerQuery queries that I would like to feed the value of a cell in my Excel file. In this particular case, the full path to the sourcefile name. Is there any way I can get this into PowerQuery?
Peter Albert
  • 15,882
  • 4
  • 59
  • 83
24
votes
2 answers

PowerQuery: How can I concatenate grouped values?

If I have the following table (shown in the image below), how can I write a grouped query that would concatenate the grouped results? For this example, I'd want to group by the LetterColumn and concatenate the NumberColumn So the desired results…
Giffyguy
  • 17,946
  • 30
  • 81
  • 147
24
votes
3 answers

What is the M language for?

I heard Microsoft developed a programming language called M. Can someone explain the use of M and how a C# programmer can benifit from M.
Embedd_0913
  • 14,911
  • 33
  • 93
  • 133
18
votes
3 answers

Is there any way to invoke PowerQuery/M outside of Excel or PowerBI?

Our BI team is really growing to like the Power Query ETL tool used within Excel and Power BI. The functional language M/PowerQuery has great utility and it would be nice to be able to utilize outside of the context of PowerBI. Is there or are there…
dkackman
  • 14,361
  • 11
  • 63
  • 118
10
votes
1 answer

Pass several parameters in StartLogin function

I am building a custom connector to connect to our API via OAuth2. This is so we can use our api as a data source to powerbi. // Resource definition Resource = [ Description = "MyAPI", Type = "Custom", …
sudeepdino008
  • 2,808
  • 3
  • 31
  • 65
8
votes
6 answers

how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I tried below query which give syntax error to me, = Number.ToText(table1.[RegionID]) & " " & table1.[RegionName] I tried…
bmsqldev
  • 2,329
  • 5
  • 22
  • 56
7
votes
2 answers

Is there a short name for Power Query Formula Language (informally known as 'M') that isn't 'M'?

As always, naming things is hard. Power Query Formula Language is long M is short Is there a nice middle ground or are we sticking with 'M'? For example, there might be conflicts when it comes to creating things like Syntax Highlighting packages in…
Jay Killeen
  • 2,392
  • 5
  • 30
  • 58
6
votes
1 answer

How to get paginated data from API in Power BI

Let's say we have this endpoint https://reqres.in/api/users. The response is { "page": 1, "per_page": 3, "total": 12, "total_pages": 4, "data": [ { "id": 1, "first_name": "George", …
David
  • 4,490
  • 6
  • 31
  • 54
6
votes
2 answers

Power Query -> Transform Comma to Period and Obtain Decimal Numbers

I'm working within Excel Query Editor (Power Query) and I have a table with many columns. Some of the numbers in those columns have a period (".") and they are properly recognized as decimal numbers, but some of them have a comma (",") and they are…
jb007
  • 213
  • 1
  • 4
  • 15
6
votes
4 answers

What advantages does using Oslo and M have and when would you use it?

After attending a talk on Oslo/M I am struggling a bit to see the advantages of using it over existing methods and in what situation it would be useful. I know its quite new and not all details have been released etc but can some one give me some…
alexmac
  • 4,125
  • 3
  • 27
  • 32
5
votes
1 answer

How to show data properly in Office Excel Using Power Query Editor?

I have below JSON output from an API, in Office Excel I am importing data via Web from API. [{ "level": 1, "children": [{ "level": 2, "children": [{ "level": 3, "name":…
Jackson
  • 922
  • 1
  • 19
  • 49
5
votes
1 answer

How to store credentials in Power BI DataConnector?

I'm building a custom Power BI DataConnector which uses OAuth. I'm following the github example. But this stores client credentials (required for the 'code flow' in OAuth) as plain text files. Is there a secure alternative to this ?
Neeraj
  • 1,895
  • 16
  • 31
5
votes
1 answer

Store Power Query custom function Online (Github etc..,) and call it

Main Question : I have created various custom functions that I frequently use. I would like to store them in a repository somewhere and call them whenever necessary. I know that I can save all those functions in an Excel file and save it in…
Gangula
  • 1,415
  • 1
  • 7
  • 26
1
2 3
…
54 55