Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
JonBaylis
Advocate III
Advocate III

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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/...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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/...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Users online (778)