Datamart: Toggling Storage Mode (From DirectQuery to Import)

[DarylK_MA]

Hello!

I am hoping to get some help from the community relating to the toggling of storage modes in datamarts; it is currently defaulted to DirectQuery but I would like to use it in Import mode. As shown in the screenshot attached, the toggle is blurred out. Not sure if anyone else is facing the same issue? 

For context, I am trying to build a datamart to store some data extracted and transformed from an SQL server. Queries take about a minute or so to resolve and that I do not have access to the server at all times when I am working with the datamart. Thus, DirectQuery is not a practical option. 

Wonder if this is a caveat since Datamart is only in a preview stage or if there is a specific toggle that either my organisational administrator or myself will need to switch on? Will appreciate any advice on this, thanks! 😀

[v-binbinyu-msft · Accepted solution]

Hi @DarylK_MA ,

To my knowledge, Datamart doesn't support this function.

Best regards,
Community Support Team_Binbin Yu