Forum Discussion

Fluxcap's avatar
Fluxcap
New Member
7 years ago

Data logging/ importing from csv files

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...

Need Help

2 Replies

  • dax's avatar
    dax
    Community Support
    7 years ago

    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.

     

  • Fluxcap's avatar
    Fluxcap
    New Member
    7 years ago

    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.