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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.