Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a PC that runs supervisory software (a SCADA system) for process automation with a PLC. The SCADA system writes the data to a continuously updated CSV file on the local C drive.
The PC is connected to the internet but is not part of my wider O365 environment i.e. there is no user account associated with it and therefore the file is not in Onedrive or SharePoint. Unfortunately, I cannot change where the file is saved (C drive).
I want to get the file or the data into our O365 environment (or another valid connection) so that I can connect with Power Query and process the data with DAX.
Is anyone aware of how I can set up to access this information automatically or any software I can install on the local PC that can write the data from the local CSV files to a CSV file stored in Onedrive, SharePoint or even directly in SQL Server if required?
I appreciate any help.
Solved! Go to Solution.
Hi @Shirani_A ,
I agree with kentyler. You could try Power Automate. There are many templates that we could use like below.
https://flow.microsoft.com/en-us/connectors/shared_filesystem/file-system/
If you have any questions, you could ask for help in the community.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Shirani_A ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Shirani_A ,
I agree with kentyler. You could try Power Automate. There are many templates that we could use like below.
https://flow.microsoft.com/en-us/connectors/shared_filesystem/file-system/
If you have any questions, you could ask for help in the community.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This sounds like a job for Power Automate. If you give it the sql server credentials it should be able to insert rows, even its not in the O365 environment.
Help when you know. Ask when you don't!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |