Get current username in Power Query via LocalDB or SQL Server
| //LocalDB | |
| UserNameLocalDB = | |
| () => Sql.Database("(localdb)\v11.0","",[Query="SELECT SYSTEM_USER"]) | |
| //LocalDB from SQL Server 2016 Express | |
| UserNameLocalDB2016 = | |
| () => Sql.Database("(localdb)\MSSQLLocalDB","",[Query="SELECT SYSTEM_USER"]) | |
| //Local instance of SQL Server | |
| UserNameSQL = | |
| () => Sql.Database(".","",[Query="SELECT SYSTEM_USER"]) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment