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.
avatar user
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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)