Forum Discussion

jneijssen's avatar
jneijssen
Frequent Visitor
9 years ago
Solved

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 na...
  • jneijssen's avatar
    9 years ago

    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!