Papercut CSV Folder Import

[norrist]

I'm trying to import the csv's that papercut exports via its data intergration tool each day into PowerBI.

I'm wondering if anyone has done this successfully, and if so would you be able to let me know how it's done 🙂 

Thanks,

Tim

[V-pazhen-msft]

If you mean you have csv export to a folder every day. You can connect to the folder with power bi, then every days you have a new csv in the folder, power bi will automatically refresh  the new file. 

Please refer to the blog:

Automatically update data according to the date in... - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[norrist]

Hi Paul,

So I've got that far but the issue I'm having is that the Papercut exports multiple different csv's with different columns in it, so when that is imported into Power bi it struggles to build the relationship between each set of data.

The 4 catergories of csv that Papercut produces are

- Accounts

- Printers

- Printer Usage

- Users

It looks like it starts importing the accounts correctly but then when it moves on to import the 'printer' csv it freaks out because the columns change name or something.

So im a bit stumped 🤔