Forum Discussion
Solved
Power Pivot data source from same workbook
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!
Thanks!
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.
4 Replies
Paola10 Hey Can you provide the file or some screenshots to understand your issue more clearly
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.
