Forum Discussion
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.
i just notice direct query are not supported transform data.
i think this is key point.
If you use sql database just try Stored procedure to import data. Its more efficent and easy to change.
stored procedure are not support. there have some configuration need to enable at mssql database.