Forum Discussion
Is there a preference between writing a sqlquery directly in PowerBI or executing a stored procedure
Hi, I understand what you mean.
There is no difference in performance.
When it comes to checking whether queries are correct, there is a difference.
When you write through POWER BI, you will notice some nuances in writing way like some issues with upper case / lower case.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What I meant was in PowerBI to get a connection to SQLServer to pull records, you can either write the SQL statements within PowerBI or wining PowerBI execute a stored procedure. I wasn't sure if there is an advantage to either method, as the most important thing would be performance.
Hi, I understand what you mean.
There is no difference in performance.
When it comes to checking whether queries are correct, there is a difference.
When you write through POWER BI, you will notice some nuances in writing way like some issues with upper case / lower case.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.