Load vs Transform Data

Hi space83 ,

We think there is no best method, only suitable method.

It depends on your requirement.

If you want to create some measures or visuals firstly, you can load the data.

If you want to do some transformations using M query, you can click transform.

But there are some limitations by using Direct Query, so you need to pay attention when you use these two methods.

Please refer this article.

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

Best regards,

Community Support Team _ zhenbw

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