Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
We currently use static configuration files in reports and data flows to calculate specific values. These files are manually uploaded by a single user, limiting their flexibility. We need a solution that allows multiple users to easily edit these files in Excel, enabling them for calculations. It’s important that these files are not tied to a single user. What is the best approach to achieve this?
You can save your Excel file to OneDrive for Business or a SharePoint document library. This will allow multiple users to access and edit the file simultaneously . Then you can connect to OneDrive or SharePoint through Power BI to get to your data.
Best Regards, Community Support Team _ Ailsa Tao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can save your Excel file to OneDrive for Business or a SharePoint document library. This will allow multiple users to access and edit the file simultaneously . Then you can connect to OneDrive or SharePoint through Power BI to get to your data.
Best Regards, Community Support Team _ Ailsa Tao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
