Set local time zone Power BI Service

Ok, here's how you do this. 

In power query add a new table by clicking "Enter Data" 

Create a column called "Dumb" with a value called "Dumber" (I use this naming convention a lot with powerbi stuff) 

Then Add a column with the formula DateTime.LocalNow()

Then save and close and now you have a Dumb table with an even Dumber way to get Local Date Time values in Powerbi service. 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSinNTUotUoqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Dumb = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Dumb", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "LocalNow", each DateTime.LocalNow())
in
    #"Added Custom"