Home

Uploaded file connection to offline file

%3CLINGO-SUB%20id%3D%22lingo-sub-1109741%22%20slang%3D%22en-US%22%3EUploaded%20file%20connection%20to%20offline%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1109741%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20created%20a%20heavily%20connected%20file%20which%20has%20about%2030%20queries%20that%20all%20relate%20to%20files%20that%20are%20based%20within%20our%20company%20sharepoint%20folders.%20I%20built%20this%20file%20offline%20with%20saved%20just%20on%20my%20desktop%20and%20then%20uploaded%20it%20to%20sharepoint.%20However%2C%20now%20when%20I%20use%20the%20sharepoint%20version%20on%20a%20different%20desktop%20it%20is%20still%20looking%20for%20the%20original%20file%20and%20I%20cannot%20figure%20out%20why.%20I%20uploaded%20the%20file%20using%20the%20%22upload%22%20button%20so%20I%20assumed%20this%20just%20created%20a%20copy%20of%20the%20file%20in%20the%20sharepoint%20structure%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20queries%20are%20created%20using%20power%20Query%20and%20basically%20import%20all%20kinds%20of%20data%20from%20a%20folder%20with%20Excel%20files.%20The%20second%20connection%20is%20to%20a%20live%20Power%20BI%20database%20using%20the%20%22Analyze%20in%20Excel%22%20add-in%20creating%20a%20pivot%20table%20from%20the%20PBI%20dataset.%20Any%20help%20would%20be%20very%20welcome!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1109741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi Guys!

 

i created a heavily connected file which has about 30 queries that all relate to files that are based within our company sharepoint folders. I built this file offline with saved just on my desktop and then uploaded it to sharepoint. However, now when I use the sharepoint version on a different desktop it is still looking for the original file and I cannot figure out why. I uploaded the file using the "upload" button so I assumed this just created a copy of the file in the sharepoint structure right?

 

The queries are created using power Query and basically import all kinds of data from a folder with Excel files. The second connection is to a live Power BI database using the "Analyze in Excel" add-in creating a pivot table from the PBI dataset. Any help would be very welcome!

 

cheers!