SharePoint Online Lists with Power Bi - Direct Live Connection, URL parameter filter and Rich Text?

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 host...