Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 use either ? (i.e. performance, parms, etc)
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |