When I create pbids file from Dremio by clicking the Power BI icon, the default setting for data connectivity mode is “DirectQuery”.
In the case of data connection with “Import” mode, the data is imported into the Power BI, so if you create or interact with a chart for visualization, the query is done in the imported data and No request is sent to Dremio unless I tried to refresh the imported data.
However, in the case of a Power BI file connected to Dremio with “DirectQuery”, the query is delivered directly to Dremio whenever a chart is created or filtered.
In this reason, when DirectQuery is used, the query load in the Dremio can be significantly increased.
Therefore, I would like to change this default setting to be {“model” : “import”}, so please let me know how .