Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Incremental refresh in Datamart: "Partition column was not found in attributes."

Submitted by Anonymous on ‎07-08-2022 09:41 AM

I have several SQL Server sources set up as Dataflows and as a Datamart.

 

In the Dataflow, incremental refresh works as expected for every single one.

 

In the Datamart, incremental refresh (using the same column) always returns the following error for every single one:

 

Partition column <date field> was not found in attributes.
HttpStatusCode
500

 

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎07-11-2022 04:03 AM

Hi @Anonymous ,

 

Do you mean that if SQL Server is used as the data source, there is no problem with incremental refresh in Dataflow but there is an error in Datamart?
I was not able to reproduce your problem, can you provide me with a detailed reproduction procedure so that I can do a better job of troubleshooting for you?

 

Best Regards,
Community Support Team _ Caitlyn

Anonymous
Not applicable
‎07-11-2022 06:56 AM

@Anonymous That's exactly right. The steps are:

 

  1. Get Data > SQL Server
  2. Select a view (in this case)
  3. Do a full refresh
  4. Open the incremental refresh config dialogue
  5. Select a date column from the drop-down list and enter retention and refresh periods
  6. Save, then the error appears

 

Let me know if screenshots would help. Happy to go through this again and grab some.

Idea Statuses