Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Shirani_A
New Member

Capturing data stored locally on non-networked PC

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.

 

1 ACCEPTED SOLUTION
v-xuding-msft
Community Support
Community Support

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/

1.PNG

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.

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.

View solution in original post

3 REPLIES 3
v-xuding-msft
Community Support
Community Support

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.

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.
v-xuding-msft
Community Support
Community Support

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/

1.PNG

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.

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.
kentyler
Solution Sage
Solution Sage

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.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.