Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Lorian
Advocate II
Advocate II

Calling views or stored procedures

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?

2 REPLIES 2
v-danhe-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.