Power Pivot : Is it possible to change Main data table without losing all measures

[Arnaud81]

Hi,

Here is my problem :

When I created my data model in Power Pivot I used Power Query to ETL my data.

Instead of adding the data to the data model (in PowerPivot) using a connection only I added the table to the workbook and then added this table to PowerPivot.

Is it possible to change this ? Using a connection only and adding the model to data model directly

I have tried several things but could find something that allows me to keep all my measures.

Thank you !!

Arnaud

 

[Matt Allington]

Bad news. There is no easy solution. Best option now is to create a dummy table (e.g. Called myMeasures), open each measure in Excel (not power Pivot) and change the table they are stored in. You can leave them in the dummy table for good if you like.