SOLVED

Power Pivot data source from same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1516193%22%20slang%3D%22en-US%22%3EPower%20Pivot%20data%20source%20from%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516193%22%20slang%3D%22en-US%22%3EHi%2C%20I%20need%20help%20changing%20the%20data%20source%20from%20a%20table%20coming%20from%20the%20same%20workbook%20-%20not%20an%20external%20source.%20Since%20there%20are%20no%20visible%20connections%20I%20haven%E2%80%99t%20been%20able%20to%20change%20it%20through%20the%20usual%20way%20for%20all%20others%20external%20data%20sources.%20I%20work%20with%20a%20large%20database%20and%20I%E2%80%99d%20like%20to%20take%20this%20specific%20table%20outside%20the%20database%20and%20make%20it%20an%20external%20source%20instead.%20Can%20anyone%20help%20me%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516193%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516426%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20data%20source%20from%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516426%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725552%22%20target%3D%22_blank%22%3E%40Paola10%3C%2FA%3E%26nbsp%3BHey%20Can%20you%20provide%20the%20file%20or%20some%20screenshots%20to%20understand%20your%20issue%20more%20clearly%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518713%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20data%20source%20from%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518713%22%20slang%3D%22en-US%22%3EHet%2C%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699938%22%20target%3D%22_blank%22%3E%40DevendraJain%3C%2FA%3E%20I%20hope%20this%20clarifies%20more.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518836%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20data%20source%20from%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518836%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725552%22%20target%3D%22_blank%22%3E%40Paola10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20in%20Power%20Pivot%26nbsp%3B%20it's%20not%20possible%20to%20change%20one%20type%20of%20data%20source%20on%20another%20type%20of%20data%20source.%20So%2C%20in%20this%20particular%20case%20linked%20table%20can't%20be%20changed%20on%20database%20source.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20only%20to%20recreate%20measures%20and%20PivotTables.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519512%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20data%20source%20from%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519512%22%20slang%3D%22en-US%22%3EThank%20you%20for%20the%20answer....%20not%20great%20but%20now%20I%20know.%20Have%20a%20nice%20day%3C%2FLINGO-BODY%3E
New Contributor
Hi, I need help changing the data source from a table coming from the same workbook - not an external source. Since there are no visible connections I haven’t been able to change it through the usual way for all others external data sources. I work with a large database and I’d like to take this specific table outside the database and make it an external source instead. Can anyone help me?

Thanks!
4 Replies

@Paola10 Hey Can you provide the file or some screenshots to understand your issue more clearly

 

Het,
@DevendraJain I hope this clarifies more.

Thanks
best response confirmed by Paola10 (New Contributor)
Solution

@Paola10 

To my knowledge in Power Pivot  it's not possible to change one type of data source on another type of data source. So, in this particular case linked table can't be changed on database source.

 

That's only to recreate measures and PivotTables.

Thank you for the answer.... not great but now I know. Have a nice day