Power Pivot connections lost in Sharepoint file

%3CLINGO-SUB%20id%3D%22lingo-sub-1445565%22%20slang%3D%22en-US%22%3EPower%20Pivot%20connections%20lost%20in%20Sharepoint%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445565%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20an%20Excel%20file%20in%20SharePoint%20(linked%20to%20a%20Team)%20with%20multiple%20tables%20and%20added%20these%20tables%20to%20a%20Power%20Pivot%20data%20model%20within%20the%20same%20file.%20The%20model%20was%20updating%20as%20expected%20while%20working%20from%20my%20office%20computer%20and%20logged%20into%20our%20network.%20Now%20working%20from%20home%20when%20I%20open%20the%20file%20in%20the%20desktop%20app%20the%20tables%20in%20Power%20Pivot%20are%20no%20longer%20connected%20to%20the%20Excel%20tables%20(%22No%20connections%20found%22).%20Why%20were%20the%20connections%20lost%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20only%20way%20to%20reconnect%20the%20tables%20is%20to%20delete%20the%20existing%20tables%20in%20the%20data%20model%20and%20add%20the%20Excel%20tables%20to%20the%20data%20model%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20I%20will%20not%20be%20able%20to%20keep%20the%20file%20in%20SharePoint%2C%20which%20is%20a%20problem%20since%20I%20have%20a%20user%20in%20a%20remote%20location%20who%20needs%20access%20to%20the%20file%20to%20update%20the%20data%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20company's%20SharePoint%20is%20in%20the%20cloud%2C%20not%20on%20a%20local%20server.%20I%20have%20two%20factor%20authentication%20turned%20on%20for%20my%20Office%20365%20account.%20Any%20ideas%20whether%20it%20is%20possible%20to%20set%20up%20the%20connection%20in%20a%20way%20that%20it%20isn't%20lost%20when%20opening%20the%20file%3F%20Is%20using%20Power%20Pivot%20in%20SharePoint%20not%20recommended%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1445565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I created an Excel file in SharePoint (linked to a Team) with multiple tables and added these tables to a Power Pivot data model within the same file. The model was updating as expected while working from my office computer and logged into our network. Now working from home when I open the file in the desktop app the tables in Power Pivot are no longer connected to the Excel tables ("No connections found"). Why were the connections lost?

 

I think the only way to reconnect the tables is to delete the existing tables in the data model and add the Excel tables to the data model again.

 

It seems I will not be able to keep the file in SharePoint, which is a problem since I have a user in a remote location who needs access to the file to update the data table. 

 

Our company's SharePoint is in the cloud, not on a local server. I have two factor authentication turned on for my Office 365 account. Any ideas whether it is possible to set up the connection in a way that it isn't lost when opening the file? Is using Power Pivot in SharePoint not recommended? 

 

 

0 Replies