J
Joe Pawlowski
Guest
So, I'm working Visual Studio Community with a Tabular Model project.
I'm trying to design a query using Native SQL query and getting this error only (so far. no syntax errors):
Expression.Error: The import SQL/dscusnoramdatamartsqlsrv02.database.windows.net;dscusnoramdatamartsqldb02 matches no exports. Did you miss a module reference?
For the life of me, I can't figure this out.
If anyone can point me in the right direction, I'd really appreciate it.
FWIW, below is the code from the Advanced Editor.
let
Source = #"SQL/dscusnoramdatamartsqlsrv02.database.windows.net;dscusnoramdatamartsqldb02",
MyQuery =
Value.NativeQuery(
#"SQL/dscusnoramdatamartsqlsrv02.database.windows.net;dscusnoramdatamartsqldb02",
"SELECT VE.fullnm AS PERSONFULLNAME,
VE.personnum AS PERSONNUM,
PC.NAME AS PAYCODENAME,
T.applydtm AS APPLYDATE,
T.adjapplydtm AS ADJAPPLYDTM,
Round (T.durationsecsqty / 3600, 2) AS WFCTIMEINHRS,
T.homeaccountsw,
LA1.laborlev1nm AS WFCLABORLEVELNAME1,
LA1.laborlev2nm AS WFCLABORLEVELNAME2,
LA1.laborlev3nm AS WFCLABORLEVELNAME3,
LA1.laborlev4nm AS WFCLABORLEVELNAME4,
LA1.laborlev5nm AS WFCLABORLEVELNAME5,
LA1.laborlev6nm AS WFCLABORLEVELNAME6,
LA1.laborlev7nm AS WFCLABORLEVELNAME7,
WE.ppstartdatedtm AS PREVPAYPERIODSTART,
WE.ppenddatedtm AS PREVPAYPERIODEND,
WE.cpstartdatedtm AS CURRPAYPERIODSTART,
WE.cpenddatedtm AS CURRPAYPERIODEND,
WE.npstartdatedtm AS NEXTPAYPERIODSTART,
WE.npenddatedtm AS NEXTPAYPERIODEND
FROM tkcsowner.wfctotal T
JOIN tkcsowner.paycode1mmflat M
ON ( M.paycodeid = T.paycodeid )
JOIN tkcsowner.jaids WE
ON ( WE.employeeid = T.employeeid )
JOIN tkcsowner.person VE
ON ( VE.personid = WE.personid )
JOIN tkcsowner.paycode PC
ON ( M.grandpaycodeid = PC.paycodeid )
JOIN tkcsowner.laboracct LA1
ON ( LA1.laboracctid = T.laboracctid )
WHERE M.effectivedtm <= T.applydtm
AND M.expirationdtm > T.applydtm
AND PC.type = 'P'
AND Substring (LA1.laborlev2nm, 1, 4) = '3493'"
)
in
MyQuery
Continue reading...
I'm trying to design a query using Native SQL query and getting this error only (so far. no syntax errors):
Expression.Error: The import SQL/dscusnoramdatamartsqlsrv02.database.windows.net;dscusnoramdatamartsqldb02 matches no exports. Did you miss a module reference?
For the life of me, I can't figure this out.
If anyone can point me in the right direction, I'd really appreciate it.
FWIW, below is the code from the Advanced Editor.
let
Source = #"SQL/dscusnoramdatamartsqlsrv02.database.windows.net;dscusnoramdatamartsqldb02",
MyQuery =
Value.NativeQuery(
#"SQL/dscusnoramdatamartsqlsrv02.database.windows.net;dscusnoramdatamartsqldb02",
"SELECT VE.fullnm AS PERSONFULLNAME,
VE.personnum AS PERSONNUM,
PC.NAME AS PAYCODENAME,
T.applydtm AS APPLYDATE,
T.adjapplydtm AS ADJAPPLYDTM,
Round (T.durationsecsqty / 3600, 2) AS WFCTIMEINHRS,
T.homeaccountsw,
LA1.laborlev1nm AS WFCLABORLEVELNAME1,
LA1.laborlev2nm AS WFCLABORLEVELNAME2,
LA1.laborlev3nm AS WFCLABORLEVELNAME3,
LA1.laborlev4nm AS WFCLABORLEVELNAME4,
LA1.laborlev5nm AS WFCLABORLEVELNAME5,
LA1.laborlev6nm AS WFCLABORLEVELNAME6,
LA1.laborlev7nm AS WFCLABORLEVELNAME7,
WE.ppstartdatedtm AS PREVPAYPERIODSTART,
WE.ppenddatedtm AS PREVPAYPERIODEND,
WE.cpstartdatedtm AS CURRPAYPERIODSTART,
WE.cpenddatedtm AS CURRPAYPERIODEND,
WE.npstartdatedtm AS NEXTPAYPERIODSTART,
WE.npenddatedtm AS NEXTPAYPERIODEND
FROM tkcsowner.wfctotal T
JOIN tkcsowner.paycode1mmflat M
ON ( M.paycodeid = T.paycodeid )
JOIN tkcsowner.jaids WE
ON ( WE.employeeid = T.employeeid )
JOIN tkcsowner.person VE
ON ( VE.personid = WE.personid )
JOIN tkcsowner.paycode PC
ON ( M.grandpaycodeid = PC.paycodeid )
JOIN tkcsowner.laboracct LA1
ON ( LA1.laboracctid = T.laboracctid )
WHERE M.effectivedtm <= T.applydtm
AND M.expirationdtm > T.applydtm
AND PC.type = 'P'
AND Substring (LA1.laborlev2nm, 1, 4) = '3493'"
)
in
MyQuery
Continue reading...