storage mode in power query

[powerbiexpert22]

is there a way to identify storage mode (import mode or direct query or dual mode) of table in power query (transformation layer) 

[Anonymous · Accepted solution]

Hi @powerbiexpert22 ,

Currently, we cannot identity storage mode in power query since it is based on data model level, not the power query transformation layer.

We suggest you check the storage mode of different tables in Model View.

Best regards,

Joyce

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