Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |