Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
@JonBaylis , depending on query or SP data retrieval speed, the data load time will vary
User | Count |
---|---|
84 | |
80 | |
69 | |
46 | |
46 |
User | Count |
---|---|
106 | |
50 | |
42 | |
39 | |
39 |