- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
10 hours ago | |||
03-04-2024 08:12 AM | |||
08-18-2023 09:10 AM | |||
08-22-2022 06:16 AM | |||
02-13-2025 03:44 AM |
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
8 | |
2 | |
2 | |
2 | |
2 |