Using Sharepoint Excel in PBI: best approach to avoid accidental user sabotage?

[falconbury]

So, apologies if this is too vague.

We're loading data into PowerBI from an Excel file in Sharepoint. The file does not belong to the BI team, and users, bless them, keep changing the filename, and/or renaming/moving the folders.

There are many different ways of getting the data in to PBI: most of them rely on a fixed filename and path being supplied (although I've seen one which filters on filename and thus gets round changes in folder path). Is there any route which uses say a file ID, which might be folder and filename agnostic, and would thus be less susceptible to user change?

[Anonymous]

Hi @falconbury 

Did DivkLearner 's method solve your problem? If so, could you please accept it as a solution? This will help more users who are facing the same or similar difficulties. Thank you!

Best Regards,
Yulia Xu

[DivkLearner · Accepted solution]

Hello @falconbury 

Can you check if this link helps you: Enable and configure unique Document IDs. 

Let me know if this does. 

Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube