Access data on Virtual Machine

[bscruggs]

- 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 BI on my local machine to the text file saved on the virtual machine?

thanks, 

B

[Anonymous · Accepted solution]

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.

[bscruggs]

Hi parry2k, 

Thanks for that. I will try and map the network drive. I do have an additional quesiton though. Will the step you outlined help me connect to an ODBC connection on the virtual machine? I.e. Power BI (local) -> Vitual Machine -> ODBC connection on virtual machine. 

thanks, 

- B

[parry2k]

@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.⚡