Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/ConnectionString2Bin.m

Last active March 21, 2017 11:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Hugoberry/e43d0f1291ca7a1ccc76c6d6189e9714 to your computer and use it in GitHub Desktop.
Save Hugoberry/e43d0f1291ca7a1ccc76c6d6189e9714 to your computer and use it in GitHub Desktop.
Download ZIP
Converting a Power BI tabular connection string to Binary
Raw
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment