Forum Discussion

bscruggs's avatar
bscruggs
New Member
4 years ago
Solved

Access data on Virtual Machine

- I am using Power BI on my desktop and need to access data on a virtual machine. Specifically, I have a text file saved on a virtual machine named "Remote Desktop". Is it possible to connect Power B...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi bscruggs ,

     

    Based on my test, For simple files on vm,such as excel, csv,text ...you may right-click it -->Choose "Give access to" --> Click "copy" as shown below:

    Then go back to local computer, open PBI--> As for my example, connect to Text/CSV -->Paste the file path( need to remove the prefix before "file" , remove the suffix ")" ,change the vm name to the VM machine path), the final file path is like this:

    file:\\10.xxx.xx.xx\Users\Admin\Desktop\Data.csv

    After entering the credentials, you could connect successfullly.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
4 years ago

bscruggs it will be better if you have file on one drive or share point, if you want to use file on remote machine, you need to map the drive or full network path.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡