Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Converting a Power BI tabular connection string to Binary
(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