Keep getting an error for the Date Table Code now


#1

Hi All,

I’m having trouble with the Date Table Code it won’t load as it looks like the query editor keeps thinking I’m loading all my other tables in Direct Query mode but I don’t want.

Trying to convert all other tables to import mode doesn’t seem to work.

This is the error I keep getting for the Date Table

“This query contains transformations that can’t be used for a live connection”


#2

Just to double check, are there any other tables that require direct query mode? or is the entire model import mode?

Don’t really ever have issues with setting this up. Have you done it previously with no issue before?

Is there anything different at all with the current model you are working with?


#3

Hi Sam,

I think I found the issue, I had the preview feature of hybrid tables (i.e direct query and import mode together) turned on.

I don’t think it liked that, once I turned off the hybrid preview it worked fine

Are you doing anything with Hybrid models yet? As I’d be very keen to see what you come up with.

I have some massive datasets from telematics I’d love to combine with imported lookup tables, I wonder if measures can be used?

Regards

Dave


#4

Interesting, I’ll have to do a review in time.

I haven’t dived into the new hybrid feature just yet but it maybe poses a few new things to get use to.