Forum Discussion

norrist's avatar
norrist
New Member
5 years ago

Papercut CSV Folder Import

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 m...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
norrist
New Member
5 years ago

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 ðŸ¤”