Forum Discussion
Move Power BI reports from Import Mode to Direct Query
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
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.
2 Replies
nagpuresushant , In the model view, when open the table properties, You have the option change storage, change it to direct query, and try
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.
