Calling views or stored procedures

Question

Hello,&nbsp;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&nbsp;the query's performance on my SQL servers?&nbsp;Which do you prefer to use?

v-danhe-msft · Answer

Hi&nbsp;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&nbsp;Regards,Daniel He

anonymous · Answer

Hi,&nbsp;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&nbsp; on the filtering

Forum Discussion

Calling views or stored procedures

2 Replies

Related content

Stored Procedure to Manipulate Tables

Stored procedure exec in lakehouse

WH is not displaying Stored procedure

Handling Parameterised Stored Procedures while migrating SSRS to Fabric

Can notebooks trigger SQL stored procedures in 2026?