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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rwhitePWT
Regular Visitor

Trying to create a Fact table and get this error. Any clue what I'm being told?

dFACT_PRODUCTION_SCHEDULE: Error Code: 999999, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Failed to insert a table., InnerException: We couldn't find partition '#{0}' in the SQL catalog. (Unique prefix: #{1}), Underlying error: We couldn't find partition 'DIM_PRODUCTION_SCHEDULE_STATUS_LI.parquet' in the SQL catalog. (Unique prefix: cf81d24e9e014456977cf36a9f9aa576) Details: Reason = DataSource.Error;Message = We couldn't find partition 'DIM_PRODUCTION_SCHEDULE_STATUS_LI.parquet' in the SQL catalog. (Unique prefix: cf81d24e9e014456977cf36a9f9aa576);Detail = cf81d24e9e014456977cf36a9f9aa576_DIM_005FPRODUCTION_005FSCHEDULE_005FSTATUS_005FLI_002Eparquet;Message.Format = We couldn't find partition '#{0}' in the SQL catalog. (Unique prefix: #{1});Message.Parameters = {"DIM_PRODUCTION_SCHEDULE_STATUS_LI.parquet", "cf81d24e9e014456977cf36a9f9aa576"};Microsoft.Data.Mashup.Error.Context = System GatewayObjectId: 31ccd070-5414-447f-93b5-7cbdd46e93fe (Request ID: 72a345cb-3302-4976-93a8-c41cf9b2e876).

2 ACCEPTED SOLUTIONS
HimanshuS-msft
Community Support
Community Support

Hello @rwhitePWT 
Thanks for using the Fabric community.

When you say that you are "trying to create a table " , how are you doing that ? Is it is using dataflow ?

If Yes , can you see if the staging option is enabled ? If yes please disable that check again .
Thanks 
Himanshu 

 

View solution in original post

rwhitePWT
Regular Visitor

It was a data flow and that did the trick. Thanks!

View solution in original post

2 REPLIES 2
rwhitePWT
Regular Visitor

It was a data flow and that did the trick. Thanks!

HimanshuS-msft
Community Support
Community Support

Hello @rwhitePWT 
Thanks for using the Fabric community.

When you say that you are "trying to create a table " , how are you doing that ? Is it is using dataflow ?

If Yes , can you see if the staging option is enabled ? If yes please disable that check again .
Thanks 
Himanshu 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Update Carousel

Fabric Monthly Update - April 2024

Check out the April 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.