Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I am facing an issue where when I try to use this Query:
let
Source = CommonDataService.Database(paramDataverseSourceDB),
SqlFilterQuery = Text.Combine({
"
SELECT
pat.column1 'ColumnName',
pat.column2 'ColumnName2',
pat.column3 'ColumnName3',
pat.column4 'ColumnName4',
FROM patient pat
"
}),
dbo_patient = Value.NativeQuery(Source,SqlFilterQuery,null,[EnableFolding=true])
in
dbo_patient
I am receiving error :
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MashupQueryEvaluator.ConvertMashupEvaluationSchemaToLoadToModelQueryEvaluationOutputAsync
I can see the data in preview, but it's not able to load in model, i guess.
Also when I use this, it is working fine:
let
Source = Sql.Database("mydata.crm.dynamics.com,5558", "mydata"),
dbo_patient = Source{[Schema="dbo",Item="patient"]}[Data]
in
dbo_patient
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.