I am currently having two major issues with my Power BI. Currently, I am using a microcontroller to upload sensor data to my OneDrive account in the form of a .csv file. The .csv files are updated every 5 minutes with the latest reading, and at midnight, they are saved to a different folder in my OneDrive with a timestamp, and the contents of the original .csv file are replaced with the newest reading at midnight.
For clarity's sake: temp.csv is updated every 5 minutes in the folder "current data". At 11:55pm, temp.csv will have 288 rows of the following format: "MM/DD/YYYY Hr:Minec, Sensor Location, Unit, #####". At 11:59pm, temp.csv is saved into "archive data" with the timestamp, i.e. "8.16.2018.temp.csv". Then, at 0:00, temp.csv contains 1 row of the previous format, with the newest sensor reading.
My two issues with Power BI are:
1) I have a dashboard to show the "temp.csv" file, as well as the other data files, that is supposed to update hourly as per the "pin a live report" button in the dashboard. It does not update hourly, or even daily.
2) At midnight, I will sometimes lose connection to the dataset. I get the following report:
Activity ID 30566b80-62c9-4cbd-9485-d9fce04dc05b