Quick Question - Raw SQL or a Stored Procedure

[JonBaylis]

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

[amitchandak · Accepted solution]

@JonBaylis , depending on query or SP data retrieval speed, the data load time will vary

https://community.powerbi.com/t5/Desktop/How-to-call-execute-a-oracle-stored-procedure-from-powerbi/...