https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-change-the-data-source-of-a-model-and-run-the-existing/m-p/1618228#M3533 <P>As far as I know you cannot connect to Pivot tables. You can connect to sheets, ranges, or tables.</P> Sat, 23 Jan 2021 14:25:11 GMT lbendlin 2021-01-23T14:25:11Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-change-the-data-source-of-a-model-and-run-the-existing/m-p/1583479#M3508 <P>I created a model based on excel file. after connecting to the data source (which is the his excel file) I created several steps and measures.</P><P>Now I realized that it could be better to used a pivot table (which is in anotehr excel file) as a data source, instead of the first excel file.</P><P>The layout is the same in both excel file and pivot table file (1st and 2nd file).</P><P>When I change the data source to the pivot table excel file, it gives me error and I cannot connect it properly nor use the steps that I created beforehand.</P><P>Error presented when trying to load new data source: "The key don't match any rows in the table".</P><P>How to make that?</P><P>&nbsp;</P><P>Thanks,</P><P>Diego</P> Wed, 06 Jan 2021 05:40:05 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-change-the-data-source-of-a-model-and-run-the-existing/m-p/1583479#M3508 Diegoaraujo 2021-01-06T05:40:05Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-change-the-data-source-of-a-model-and-run-the-existing/m-p/1618228#M3533 <P>As far as I know you cannot connect to Pivot tables. You can connect to sheets, ranges, or tables.</P> Sat, 23 Jan 2021 14:25:11 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-change-the-data-source-of-a-model-and-run-the-existing/m-p/1618228#M3533 lbendlin 2021-01-23T14:25:11Z