Computed Entity in Dataflow

[Dom87326]

Hello,

Problem statement: We are trying to create a computed entity in dataflows on existing dataflow table that's source is a snowflake instance housed in AWS with built in connector (without gateway). :

Source = Value.NativeQuery(Snowflake.Databases("Server_name","Warehouse_name"){[Name="Table_name"]}[Data],
"SELECT * from Table_name#(lf)WHERE ""%DATE_KEY"" >= '"&DATE_KEY&"'", null, [EnableFolding=false])
Where Date Key is Text type Date parameter. We also perform some calculations on a new entity whose source is the referenced entity, such as merging other tables.  

We want to know: It seems that when we add this Computed Entity Tab;e (See attached Capture1, table Fact) to the datamodel in DirectQuery it return an error (see attached Capture2, Error), however original Source Fact work fine.

If anyone has similar axperience, any help would be highly appreciated. 

Thanks! 

[v-easonf-msft · Accepted solution]

Hi,  @Dom87326 

This is a  general error message, and it is difficult to investigate the specific cause based on this.

You need to create a support ticket in Power BI Support for further investigation.They will have better suggestions.

Best Regards,
Community Support Team _ Eason