cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dom87326
Frequent Visitor

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! 

 

Capture2.JPG

 

Capture1.jpg

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

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

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!