The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to Solution.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingPut 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks! I didn't know that about SharePoint so that just made my life so much easier! Really looking forward to working with Power BI.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
22 | |
12 | |
11 | |
9 |
User | Count |
---|---|
113 | |
31 | |
30 | |
21 | |
19 |