Forum Discussion
Is PowerBI the tool for me?
A current recurring task we have is that we get nightly sales reports via FTP which are loaded in to SQLServer. This data is then manipulated through SQL views and exported into Excel where graphs, c...
a_mixed_life
Resolver I
Resolver IAs others noted here, they have very good suggestions. I would like to add that since your reports are imported into SQL and then manipulated in SQL Views, then all you really need is configure PowerBI to connect to the SQL View then you're set. With an assumption that FTP > SQL is automated.
PowerBI will eventually have an option in upcoming releases for email notifications that will help with notifying your users. And depending on how you design the 'report' in PowerBI, your users have the ability to export to Excel if they need to.