Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Last active March 21, 2017 10:33
Embed
What would you like to do?
Get Power Query data source Connection String
(port as text) =>
let
//Get $Embedded$ database name
catalog = AnalysisServices.Databases("localhost:"&port)[Name]{0},
//Run DMV query to get data source details
dataSources = AnalysisServices.Database("localhost:"&port,catalog,
[Query="select * from $system.TMSCHEMA_DATA_SOURCES"])
in
dataSources[ConnectionString]{0}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment