Forum Discussion

LizPerry's avatar
LizPerry
Frequent Visitor
8 years ago
Solved

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...
Need Help
  • LizPerry's avatar
    LizPerry
    8 years ago

    Thanks for your reply Anonymous. We haven't yet linked to Oracle, IT have agreed it but they're outsourced so I'm struggling to engage with them. What I'm not clear on is once we're connected whether the set up will be appropriate, documentation seems to suggest we need some kind of analysis service and I know that IT have suggested that connecting multiple users to Oracle will slow the network down and they're not keen on that but we want to implement PBI as an enterprise solution not as a system we update with multiple disconnected Excel spreadsheets. I was looking for advice from other users perhaps on Oracle, what their set up is ie. do they have a specific analysis layer to deal with PBI etc. also anyone who might be dealing with outsourced IT, how best to lead this kind of implementation?

    Thanks,

     

    Liz.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

LizPerry,

Do you get any issues when connecting to the Oracle data source in Power BI Desktop?I am not very clear about your requirement which refers to the model.

Regards,
Lydia

LizPerry's avatar
LizPerry
Frequent Visitor
8 years ago

Thanks for your reply Anonymous. We haven't yet linked to Oracle, IT have agreed it but they're outsourced so I'm struggling to engage with them. What I'm not clear on is once we're connected whether the set up will be appropriate, documentation seems to suggest we need some kind of analysis service and I know that IT have suggested that connecting multiple users to Oracle will slow the network down and they're not keen on that but we want to implement PBI as an enterprise solution not as a system we update with multiple disconnected Excel spreadsheets. I was looking for advice from other users perhaps on Oracle, what their set up is ie. do they have a specific analysis layer to deal with PBI etc. also anyone who might be dealing with outsourced IT, how best to lead this kind of implementation?

Thanks,

 

Liz.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    LizPerry,

    I don't think this is a Power BI issue. How do you share Power BI report to users?

    In the case that multiple users are viewing Power BI report at same time, which increases network load, it is better to contact network administrator about how to improve network bandwidth.

    Regards,
    Lydia

    • LizPerry's avatar
      LizPerry
      Frequent Visitor
      8 years ago

      Thanks Anonymous no I agree it isn't a Power BI issue, I was just looking for some shared knowledge from other Oracle users. I might need to re phrase my question.

      Thanks,

      Liz.