Direct Lake model over deployment pipeline

[wardy912]

Hi everyone,

 I've deployed a direct lake model to from dev to test using a deployment pipeline and refreshed the data. All data tables have been loaded successfully, but the measures table, calculation groups and field parameters (basically everything that is import storage mode) will not load. The only information I have is 'invalid date'. Can anybody tell me what I need to do to fix this please? Thanks

[wardy912 · Accepted solution]

Strange fix for this, I renamed my measures table to 'measures_' and all tables loaded.

[tayloramy]

Hi @wardy912, 

Glad you resolved it. I'm pretty sure Measures is a reserved table name, not sure why it even let you make that. 

I typically use _Measures in my reports, probably stemming from my background in computer science and _ indicating internal variables. 

[wardy912]

Thanks @tayloramy 

 A little trick I picked up, call the table [ Measures] to get 'Measures'