Forum Discussion
Report Access via Report URL (with URL filtering) slow
I’m accessing a report though a URL you get when you Share. It’s the one that you get from the Shared With Me area. We have hyperlinks from an internal website to filter the report with values that are generated dynamically on that site via the url.
It seems to me that there is a good 5 seconds of overhead involved when accessing reports in this manner. If I have app.powerbi.com already loaded up, the report loads quickly. Performance Analyzer in the desktop shows ~1300ms. There’s not much I can do to make this go faster from a report perspective.
Does any one have any suggestions here or is this just a limitation of the service?
It seems to me that there is a good 5 seconds of overhead involved when accessing reports in this manner. If I have app.powerbi.com already loaded up, the report loads quickly. Performance Analyzer in the desktop shows ~1300ms. There’s not much I can do to make this go faster from a report perspective.
Does any one have any suggestions here or is this just a limitation of the service?
5 Replies
- GilbertQ
Super User
Hi there
I would suggest that you look at your report performance, taking 1300ms is a long time for a report to run. Typically I would imagine it would be less than 300ms
That is why when you are accessing it via the URL Filter, it will take the initial time that you see in Power BI Desktop, plus additional time to apply the URL filter.
Possibly there could be some improvements made in your data model and measures?Thank you for your response but if we're talking about the delta between 1300ms and 300ms that's a whole second. I would be totally fine if the page loaded in a second but I'm seeing more in the range of 7 seconds. Even if the Performance Analyzer showed your 300ms number, I'd still be looking at a 6 second run time.
I found this: https://youtu.be/8ASw-J0PuN8?t=360
And this video is more in keeping with the performance I'm seeing. It takes about 6 seconds to just load the page and then AFTER that you start seeing the swirling circles for the visualizations to appear. That's what I'm seeing too. Is this typical performance for this feature?
- GilbertQI see what you are saying.
That would be expected, because not only does the browser have to go to the site, it has to then authenticate.
After that it would then find the report, find if there are any URL Filters, if there are any report page filters, apply them all.
Then fire off the queries to the Analysis Services model to get back the query results.
And finally once all the above render the results.
I would think based on all the above, your internet connection, the speed of your PC (For running Power BI in the Web) as well as critically your data model to answer the queries really quickly, it is to be expected.
