Alternative to direct query method

I have a fct table in snowflake database with almost 1.5 billions rows. How can I lmport it to power bi instead of direct query .

because Direct query wont allow us to do tranformations in query editor.

please suggest me alternative way to get the data load to power bi .