Changing Direct Query to Import Storage Mode

Please follow given links ... these link will help you how to solve the issue.

https://community.fabric.microsoft.com/t5/Desktop/Convert-storage-mode-from-direct-query-to-import-data-source-as/td-p/3025437

https://powerbiconsulting.com/direct-query-vs-import-mode-in-power-bi/

https://www.youtube.com/watch?v=-ip7mKUdwRg

https://community.fabric.microsoft.com/t5/Desktop/Convert-storage-mode-from-direct-query-to-import-data-source-as/td-p/3025437

https://community.fabric.microsoft.com/t5/Desktop/How-to-change-direct-query-to-import-query/m-p/100996

OR

Switching from Direct Query to Import mode in Power BI can be a bit tricky, especially if the option is disabled in your Model View. Here are some steps you can try to change the storage mode:

1. Check the Status Bar: Sometimes, you can change the storage mode directly from the status bar at the bottom right of Power BI Desktop. Look for a text that reads “Direct Query: On (Click Here To Change)” and click it to switch to Import mode.

1.            Use the Advanced Options:

> Go to Model View.

> Select Advanced from the ribbon.

> If the storage mode option is still disabled, this method might not work for your specific setup.

1.            Create a Calculated Table:

> Create a new calculated table from your Direct Query table. This new table will be in Import mode.

> Use this calculated table for your relationships and visuals instead of the original Direct Query table.

1.            Add a CSV File:

> Create a simple CSV file and load it into your Power BI model.

> When prompted, switch all tables to Import mode.

> Delete the CSV file from your model after the switch.

1.            Recreate the Report:

> If none of the above methods work, you might need to recreate your report by connecting to your data sources again and choosing Import mode during the initial setup.

These steps should help you migrate your report to Import mode, which can significantly improve performance. If you encounter any issues, feel free to ask for more specific guidance!