SOLVED

Power Pivot data source from same workbook

Copper 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 (Copper 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
1 best response

Accepted Solutions
best response confirmed by Paola10 (Copper 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.

View solution in original post