Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next 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

ConvertMashupEvaluationSchemaToLoadToModelQueryEvaluationOutputAsync

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 :

blaze_leo_0-1773897520968.png


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

 

Status: New