Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago
Solved

Computed Entity in Dataflow

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! 

 

 

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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