March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
4 | |
4 | |
3 | |
2 |