Switching data source from Direct Query to Import Mode

[Anonymous]

Hi

I have a report that is using 2 different data sources, both from Microsoft Azure. Both are currently running as Direct Query but I would like to change one of them to import.

I can't figure out how to swap one to Import without swapping both.

Any guidance would be greatly appreciated.

Thanks

Victoria

[dax · Accepted solution]

Hi VictoriaQ,

You could try to change this like  below(Click View->check Field Properties, then set storage mode like below)

You could refer to Storage mode in Power BI Desktop for more details.

Best Regards,

Zoe Zhi

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