Move Power BI reports from Import Mode to Direct Query

[nagpuresushant]

Hi,

In Power BI Desktop, I have CDS (Dataverse) as my data source and I have developed reports in 'Import Mode'.

Now, since couple of weeks back we are getting option to use Direct Query for CDS, and I want to move all my existing reports to Direct Query, is there any option to do so? 

Thanks,

Sushant

[v-yangliu-msft · Accepted solution]

Hi  @nagpuresushant  ,

As far as I know, it is not possible to convert import mode to direct query mode, But direct query mode can be converted to import mode

If you really need to change it to direct query,

my suggestion is to create a new one using direct query then copy your applied steps from your previous report.

It will be quite time consuming but it will achieve your requirement.

Best Regards,

Liu Yang

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

[amitchandak]

@nagpuresushant , In the model view, when open the table properties, You have the option change storage, change it to direct query, and try