Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
This question is a "getting others thoughts" from the folks of the PBI community. We are putting together a process for taking excel files filled out by people in the field > submitted and placed in SharePoint > and added to a PBI Template for reporting and cast on a TV. Right now this is a manual process (adding the file location to the template and publishing)..... but we are trying to automate it as much as possible.
1.) Is it possible...... that when a excel file is placed in the SharePoint folder as NEW, that it can automatically be added to the PBI Template? Could we also automate the publishing??
2.) is it possible..... These excel files, initially placed in the SP folder as NEW, are constantly updated throughout the day. The users in the field, update their excel files and will "replace" the same name excel files that were in the SP library. Basically replacing/overwriting the files. (Yes i know this is not optimum and i am working on a better and logical solution but for now they use excel files and constantly update them). By doing it this way, will it break #1, if #1 is even possible??? What could i do to make this work??
here is a screenshot of how it works.... Excel > SharePoint > PBI > Cast
thoughts and suggestions much appreciated!!!! Thank you in advance!!!
1. yes and yes. Use the Sharepoint Folder connector and process any files that are in that folder, or that satisfy other conditions (namepattern, for example
2. Sure. Be aware that there might be hickups when the Power BI Service tries to access the file while the user is updating/replacing it. BE AWARE that users are notoriously bad at maintaining the structural integrity of the Excel files. Build lots and lots and lots of safeguards into your Power Query code.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |