Forum Discussion

KilJhard's avatar
KilJhard
Frequent Visitor
3 years ago
Solved

Easy Question: File Location

Hey everyone,

I've been slowly learning Power BI off and on over the past couple of months and the company I work for is finalizing the final steps to have Power BI 365 added to my profile to start creating reports/dashboards for my department.  I'll be the first in the company, in Canada to have access to it which means there is no internal support and I'll be going through the whole process blind, which I'm excited for! 😄

My only question right now is the data we'll be using to create the reports/dashboards and where to best save it.  I have my own one drive but obviously if I leave the team, or the company then they'll lose access and have to start all over again.  I also recently built a SharePoint site for our department/Canada and was suggested to just save it there in the documents folder but I'm sure in one of the many courses I've taken it was advised against it as it'll read slower the larger the data/file becomes.

So I guess the question is, would it make sense to just have a dedicated one drive for the file(s) so everyone who will need to, can update it and access it, or is SharePoint a perfectly viable place to put the data?

  • Put it in SharePoint. That is OneDrive for Business as well. It is a universal locaition that security can be controlled by site membership (or Teams membership - Teams sits on top of SharePoint), Power Query can easily access it, and people leaving and being hired have no effect on it. It is also a cloud location so no on prem gateway is necessary.

2 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion

    Put it in SharePoint. That is OneDrive for Business as well. It is a universal locaition that security can be controlled by site membership (or Teams membership - Teams sits on top of SharePoint), Power Query can easily access it, and people leaving and being hired have no effect on it. It is also a cloud location so no on prem gateway is necessary.

    • KilJhard's avatar
      KilJhard
      Frequent Visitor

      Thanks!  I didn't know that about SharePoint so that just made my life so much easier!  Really looking forward to working with Power BI.