Question: how to change import data to directquery in power bi?
Answer: Open Power Query Editor by clicking Edit Queries.
Make sure the top query is selected.
Hold the Shift key and click on the bottom query — this will select all queries.
Press Ctrl + C.
Open your favorite text editor (like Notepad).
Press Ctrl + V.