Power BI

I am currently using Azure Cosmos DB for our IoT platform and am planning to switch to another #NoSQL database for cost and other related issues. I am also looking for a database that has higher capabilities towards reporting solutions through Power BI or other reporting tools.

Looking for the best analytics software for a medium-large-sized firm. We currently use a Microsoft SQL Server database that is analyzed in Tableau desktop/published to Tableau online for users to access dashboards. Is it worth the cost savings/time to switch over to using SSRS or Power BI? Does anyone have experience migrating from Tableau to SSRS /or Power BI? Our other option is to consider using Tableau on-premises instead of online. Using custom SQL with over 3 million rows really decreases performances and results in processing times that greatly exceed our typical experience. Thanks.

We are looking for visualizations tools that can afford access to many different platforms. We are short on engineers to support connections and want to be minimally reliant on them. We have exhausted our vertical capabilities and now are looking to branch data across disparate systems.

I found Power BI complicated, I am wondering what others have found.