Our PowerBI team would like to create a report based on the CSV file which is placed in the Windows Server's file location. (eg. lets say D:\Report files).
In our Windows server we have SCP (SFTP client) installed, now here is the following questions that may help us,
Is it possible to transfer the CSV file to the OneDrive location using SCP (SFTP client)?
Is it possible for PowerBI can fetch the CSV file from Server's file location?