Forum Discussion
BIDanny
2 years agoFrequent Visitor
Union three sources
Hey all! Struggling a bit here... Why doesnt this work?
let
UAT = Sql.Database("uat-sqlserver.database.windows.net", "uat-operation-db", [Query="
select 'UAT' [Environment], Id, GroupId, Name from Customers where EnableBiDashboard = 1
"]),
RC = Sql.Database("uat-sqlserver.database.windows.net", "rc-operation-db", [Query="
select 'RC' [Environment], Id, GroupId, Name from Customers where EnableBiDashboard = 1
"]),
PROD = Sql.Database("prod-sqlserver.database.windows.net", "prod-operation-db", [Query="
select 'PROD' [Environment], Id, GroupId, Name from Customers where EnableBiDashboard = 1
"]),
Source = Table.Combine({ UAT,RC,PROD})
in
Source
Ha! Thanks for that AnalyticPulse - Sometimes you just need to take a step away, and come back
"Can't see the forest through the trees"
The syntax was wrong where the RC server was specified! 🙂
2 Replies
- AnalyticPulseSolution Sage
you're supposed to tell the error you're getting in order to solve it.
- BIDannyFrequent Visitor
Ha! Thanks for that AnalyticPulse - Sometimes you just need to take a step away, and come back
"Can't see the forest through the trees"
The syntax was wrong where the RC server was specified! 🙂