Data logging/ importing from csv files

[Fluxcap]

I've been tasked with finding an alternative solution to using dedicated data historian packages for historizing data. This will grow to be hundreds of data points logged every second into a csv file. Importing the data seems simple enough. Just not sure this (Power BI) is the best solution...

[Fluxcap]

I have multiple devices at remote sites that log time stamped process data (pressure, temperature, etc) every second to a local csv file and periodically push those out to folders in an in house ftp server. Rather than keep accumulating csv files, I'd like to import them into some sort of database where the data can be accessed as necessary. Is Power BI the right tool for this? I know this is kind of vague, but I"m trying to avoid the gotcha's down the road.

[dax]

Hi Fluxcap,

What did you mean the Data logs? Where did it store? If they store in datasource, you could try to connect this by datasource in PowerBI. And you also could load this in CVS file and import this in PowerBI. If this is  Azure Monitor log, you also could refer to Import Azure Monitor log data into Power BI for details.

By the way, import mode will have1-GB dataset limitation.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.