I currently am running a 2016 SP Server enterprise instance with a separate SQL server for our data. We are looking at using Power BI to replace our current reporting functionality. I'm new to this as we were previously on a 2010 environment utilizing Crystal Reports. FTR - I'm well versed in 2016 development but I've never used Power BI before. So bear with me!
I've downloaded the gateway on our SQL server instance and then downloaded the Power BI Desktop version. Through the Power BI desktop version, I'm able to pull lists and data directly from one of our sharepoint website lists. What is the purpose of the gateway, then? Is it just unnecessary since I have the desktop version of Power BI?
The desktop version seems to make some sense to me, but it's also slightly confusing. Basically we have financials that we are looking to create sums of based on user-selected variables. For example, the user may only want to see financial information for one specific user, but also maybe for 3 selected users. Does Power BI reporting allow for this type of reporting service? Or does each report need to be created and then compiled by the developer and then exported to the end-user? Ultimately, I'm trying to figure out how an end-user would be able to pick variables to report on that wouldn't require developer intervention every time.
Lastly, if all of this is possible does anyone have a good learning tool to help me get up to speed with just how in depth the reporting functionality can be? I feel like most of the resources I've found are basic reporting. Aka: import a list and then let Power BI do it's thing.
Thanks for the help.