We've been testing and have run into these challenges that are keeping us from replacing SSRS.
* No Direct Live connection to SPO Lists. If Azure DBs have one, why not SPO lists that are hosted in Azure and have REST APIs? 24 hours to refresh a report really limits what we can do.
* No native SharePoint Online webpart for PowerBi.com published reports. We need to filter reports by url query string and web part connectors
* No native Power Bi Rich Text and HTML field type. We can't display rich multiline fields. We were able to do this in SSRS
Anybody else interested in these? Any chance we will see them any time soon?
Thanks.
If interested, please vote these up:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15883971-live-data-connections-to...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7166475-rich-text-html-support-in...
