Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

change data source power

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Change Data Source in Power Pivot

Change Data Source in Power Pivot

ResolvedVersion 2013

Tsudoi has attended:
Excel PowerPivot course
Excel VBA Introduction course

Change Data Source in Power Pivot

Hi,
Please how do you change Data Source in Power Pivot that was created from a table by Adding To Data Model within same workbook in the same way you do normal pivot table?
Is it possible? If so, please show me how?

RE: Change Data Source in Power Pivot

Hi Tsudoi,

Thank you for the forum question and I hope that you are fine.

It is possible if you had the table in another workbook. The only way of doing it if you have the table in the same workbook as the data model, is to copy the new data and paste the data in the source table in your worksheet. Otherwise you will have to connect to the new table and build in the new table in your data model.

If you had loaded the table through Power Query, it was an easy task.

Unfortunately I cannot find any "smooth" solution.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Change Data Source in Power Pivot

Hi Jens,
Thanks again for your reply. I hope you're well.
Understood that it has to come from another workbook by creating a new connection. No problems, I will do it that way.
In the meanwhile I have posted another question about DAX which is more important and complicated. If anyone can have a dig please...
Thanks again

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.