Direct Query Relationships

[Mumin192]

Hello,

I'm importing sql tables in 'Direct Query' mode

I need to create a calendar table that connects between them

Is it OK to create a calendar table, or it should be imported also in 'Direct Query'?
When I created one and created a relationship, it showed a space in the raltionship line at the beginning and end of it. Does this mean anything like it will not give accurate results?
Thanks

[Anonymous]

Hi @Mumin192 ,

As far as I know, if you add a calendar table into your data model, your connection mode will change to mixed mode. 

If you want to keep direct query connection in your data model, please load a calendar table from SQL Server.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Mumin192 , Better to have at source. but both work, Table in Power BI and Table at source

Direct Query - End to End (Connection to Publish): https://youtu.be/cf-YNWX8Qow

https://youtu.be/cQfJ0GmQ5os

https://youtu.be/24arfrD3Qzk