Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jneijssen
Frequent Visitor

Change PowerBI datasource for Excel Pivot Table

Dear All,

 

I have created a Pivot Table in Excel (not Power Pivot) using PowerBI Service as a Datasource. I have created this link using the PowerBI Plugin for Excel.

 

Now I have changed the name of the Report and Datasource in Power BI Online and the link from Excel to PowerBI is not working anymore (logically I assume).

 

How can I select a new datasource / change the datasource to the correct PowerBI Datasource for my Pivot Tables, not having to rebuilt all my Pivot Table reports again? 

 

Is this possible? Hope this is an easy question, and I can get some help soon. I have been trying for days, but Excel keeps crashing when I try to edit the connection.

 

Thanks for your help in advance!

 

Kind regards,

 

Jochem

1 ACCEPTED SOLUTION
jneijssen
Frequent Visitor

Found the solution myself.

 

1. Create a new link with the PowerBI Plugin "Connect Data" within the "PowerBI"-Menu.

2. Go to the Pivot Table with the old/wrong Datasource connected.

3. Select "Change Datasource" in the "Pivot Table"-Menu.

4. Choose the correct connection that was just generated.

 

Works fine!

View solution in original post

1 REPLY 1
jneijssen
Frequent Visitor

Found the solution myself.

 

1. Create a new link with the PowerBI Plugin "Connect Data" within the "PowerBI"-Menu.

2. Go to the Pivot Table with the old/wrong Datasource connected.

3. Select "Change Datasource" in the "Pivot Table"-Menu.

4. Choose the correct connection that was just generated.

 

Works fine!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors