I’m trying to set up a Power Bi report that will work for multiple users – the usernames are unknown.

The data I want to manipulate will be generated by another program and will consequently end up in their program files. It is CSV files. There is also an XML file generated somewhere but I don’t know where.

All the data connections I try want a user name and password or a file address, which won’t work for multiple users.

How can I set up a datasource that can look for the program files without a username or file path?

I tried ODBC, Text/CSV, XML, OLE DB – they all seem to need direct file addresses