Power Query/M Formatter

[ppvinsights]

Hi Group,

we developed a formatter for M/PowerQuery a couple of weeks ago. You find it here:

https://powerqueryformatter.com

You can format M-code online or use our API - as we use the API for our (german) blog https://durchblick-durch-daten.de (formerly https://powerpivotinsights.de). 

Please give it a try - and if you have any suggestions or if you find any problems, do not hesitate to send a bug report (link is on the website).

Thanks,

Holger

[jzadok]

Hello. Has the PQ Formatting tool http://powerqueryformatter.com/ been retired?

I use fairly often and found the site appears to be down. Confirmed on another web browser and came to the same result. 

[Greg_Deckler]

Very nice, I did something simple but it worked great! Turned this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dc3BCQAhDETRXnIWSWLGaC1i/21sFPawkJ3rY/hrkVAhqfwd7bIIIWopWVBPpZ1TKvob6keUU+OK+3NXQxvgyYC+ZremMgQT1hzeZ9h+AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [z = _t, #"GAMMA (Excel)" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"z", type number}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"GAMMA (Excel)"})
in
    #"Removed Columns"

Into:

let
  Source = Table.FromRows(
    Json.Document(
      Binary.Decompress(
        Binary.FromText(
          "dc3BCQAhDETRXnIWSWLGaC1i/21sFPawkJ3rY/hrkVAhqfwd7bIIIWopWVBPpZ1TKvob6keUU+OK+3NXQxvgyYC+ZremMgQT1hzeZ9h+AA==", 
          BinaryEncoding.Base64
        ), 
        Compression.Deflate
      )
    ), 
    let
      _t = ((type text) meta [Serialized.Text = true])
    in
      type table[z = _t, #"GAMMA (Excel)" = _t]
  ),
  #"Changed Type" = Table.TransformColumnTypes(Source, {{"z", type number}}),
  #"Removed Columns" = Table.RemoveColumns(#"Changed Type", {"GAMMA (Excel)"})
in
  #"Removed Columns"

Much more readable and it had colors as well but those didn't paste over! Not your fault! 🙂

[ppvinsights]

Hi Greg,

what do you mean with "colors didn't paste over"? If you cut/paste it to something like "word", this is working. If you copy"html" you can use it on your webstie (with colors). Ok, using the powerquery - we do not have a change because this is text only 🙂

Holger

[Greg_Deckler]

Yep @ppvinsights I figured it out, HTML copy, super cool

[Greg_Deckler]

So cool, has a copy HTML feature so you CAN get the colors to paste over!! 🙂

let
  Source = Table.FromRows(
    Json.Document(
      Binary.Decompress(
        Binary.FromText(
          "dc3BCQAhDETRXnIWSWLGaC1i/21sFPawkJ3rY/hrkVAhqfwd7bIIIWopWVBPpZ1TKvob6keUU+OK+3NXQxvgyYC+ZremMgQT1hzeZ9h+AA==", 
          BinaryEncoding.Base64
        ), 
        Compression.Deflate
      )
    ), 
    let
      _t = ((type text) meta [Serialized.Text = true])
    in
      type table[z = _t, #"GAMMA (Excel)" = _t]
  ),
  #"Changed Type" = Table.TransformColumnTypes(Source, {{"z", type number}}),
  #"Removed Columns" = Table.RemoveColumns(#"Changed Type", {"GAMMA (Excel)"})
in
  #"Removed Columns"

[Greg_Deckler]

Just added this to my favorites bar!