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.

bscruggs's avatar
bscruggs
New Member
4 years ago

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