Converting a Power BI tabular connection string to Binary

ConnectionString2Bin.m

(connectionString as text) =>
let
//Define a semicolon splitter
   split = Splitter.SplitTextByDelimiter(";"),
//Split the connection string by semicaolon and assume that Mashup is the last element
   mashup = Text.Replace(List.Last(split(connectionString)),"Mashup=","")
in
//Convert base64 string to binary 
   Binary.FromText(mashup)