Quick Question - Raw SQL or a Stored Procedure

Hi,

I am importing (so no direct query needed) data into PBI desktop and I just wondered whether anyone had any preference/reasoning to using the raw SQL code for their query in PBI desktop or whether to use a stored procedure (SP) instead i.e. just EXEC the SP in PBI desktop and have all your code in the SP itself.

Thoughts welcome.

Thanks,

Jon