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