Implementing and connecting to data when your IT is outsourced, best practice guidance needed please

We're at the point where we have tested PBI and really like the visualisation it offers. We're dealing with millions of rows of orders and sales data so in contrast to Excel PBI has really given us t...