Get Data from a file in my OneDrive Account

[johnrenniecoredata]

I have set up a data connection to a file on my harddrive but it can only be refreshed from my computer. I want to create a connection to a file in my OneDrive folder on the cloud so that I can update the data from other computers. The path will reference a file in the cloud opposed to a file on my computer.

I haven't been able to find a way to connect to a file on the cloud. I can do it in PowerBi but cannot find a way of doing it using Get and Transform in Excel 2016.

Does anyone know if this is possible?

 

[ebraatz]

Hi, Did you ever find a solution?