>- Create Power BI reports in the browser. It's true, in Report Server, you can't create reports in the browser. You create them in PBI desktop, and then someone with sufficient rights can deploy to the server

I think that the support of creating ad hoc queries would suffice.

>- Dashboards - this is just damn misleading. In the PBI Service, there is a a feature where you can select components from existing PBI pages and construct your own "electronic bulletin board". But you're not authoring any specific visuals.

Basically, I am looking for list support such as on this site.

>- Automatic page refresh for DirectQuery models.......that is true, though to be honest, I've used PBI report server since 2018 and have not had a need for it at all.

Assuming the data populating those reports is received from various static files on disk, processed into the database, and the need to have the reports to be refreshed in Power BI. The incoming static files will come at any time. Scripting process would do its job to update the database. Then, it's a matter of refreshing everything down under. Either this would be done manual or with automation. The main result is to be able to have the reports to be updated into the browser when needed.

>Cross-report drillthrough: out of the box, that's true but misleading. There is no native support for it in PBI report server, but there are people who have found workarounds.

In here, are we making reference to the fact that from one report, we could click on a specific column and obtain a sub report?

>That has been my only frustration with PBI report server - having to wait 3-4 months to support new features they they support right away in the service. Aside from that, I've been able to author the same kind of report content - and hopefully you can see from the one sample dashboard I deployed (the COVID one) that I don't merely "dabble" in this area. Everything in that entire set of pages, could have been done on PBI report server.

Thanks for all the details, this is very helpful.