Forum Discussion
Solved
Is there a preference between writing a sqlquery directly in PowerBI or executing a stored procedure
Hi, PowerBI Desktop allows a connection to SQLServer and to either write the SQL directly within PowerBI or executing a stored procedure within PowerBI. Is there any preference of when to...
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.
Using SQL is the best way to write SQL 🙂
There have been times when an editor at PBI missed errors.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.