Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When importing data using the refresh schedule on the Report Server - is there a performance difference between calling a view or executing a stored procedure? What about if it's being refreshed multiple times a day? Or is it solely dependent on the query's performance on my SQL servers?
Which do you prefer to use?
Hi @Lorian,
Based on my research, when you have imported your data, the performence may refer to the report server database.
You could refer to this link:
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh
Regards,
Daniel He
Hi,
both methods create a execution plan on the SQL Server. You must beware of parameter sniffing by SP.
But in my mind there is no opposite on the performance. But I prefer Views, these are gives me a better handling on the filtering
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |