Power BI has started being implemented at our company recently, meaning that we are still in the discovering phase. So far what we have uncovered is beyond fantastic! We have built several automated processes capturing input data onto Sharepoint and Power BI was just there to pull the data from it. Power BI was also there to let us implement a live connection to our database. Given the experience we acquired with Power Query from Excel, transitioning to Power BI represented no problem at all for us, it also lets us utilize SQL statements creating a swell link onto that database without crowding the query with unnecessary applied steps (it helps with the data load speed to increase exponentially). The Streaming datasets we were able to creating using Power Automate, bring power to our reports and dashboards for ease of access to users getting the most updated data without breaking a sweat. The integration of embedding Power BI was easy and the display is phenomenal. Even when there are times that for some reason datasets don't refresh correctly (this occurs mostly with scheduled refreshes), we immediately receive email notification with details on what we should be looking at to find a fix. The other portion of Power BI that probably doesn't get as much credit, is the online version of Power BI reports; its option to analyze reports in Excel allows us to send quick ad-hoc reports upon request. Review collected by and hosted on G2.com.
There are very few things I think Power BI could improve but that perspective I have it only based on what I needed in the moment. Power BI can't be connected to provide information out to Sharepoint. Having that option would've help skipping the workaround we utilize by building a dataset in Power BI then publishing that report and use a gateway where we could've connected the data directly. The Dataset ended up being a table that could've easily provide that information to be read utilizing Power Automate. Which is what we end up doing. Review collected by and hosted on G2.com.
