Forum Discussion
Paola10
Jul 11, 2020Copper Contributor
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 ...
- Jul 13, 2020
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.
DevendraJain
Jul 11, 2020Iron Contributor
Paola10 Hey Can you provide the file or some screenshots to understand your issue more clearly
- Paola10Jul 13, 2020Copper Contributor
- SergeiBaklanJul 13, 2020Diamond Contributor
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.
- Paola10Jul 13, 2020Copper ContributorThank you for the answer.... not great but now I know. Have a nice day