Hi Mynda,
Prior to doing your Power Query course and getting more proficient in Power Query, I had imported a table from my workbook into Power Pivot where I had created relationships so that my slicers could be linked to different pivot tables/charts. I then deleted the excel sheet containing the data as I remember you saying in one of your webinars that to reduce the file size you can delete the excel sheet as the data is in the Power Pivot cache but I didn't think of the consequences of doing that - I can't add new data to the table as the table doesn't exist anymore. I now have to add new data to the table and can't figure out how to do this. I have googled but not getting anywhere. I can't paste append as the original data was not pasted in to Power Pivot.
Is there anything I can do or will I have to re-run my original data set and start again using Power Query this time?
tnx
Tracy
Hi Tracy,
Nothing you can do to add data to it. You'll have to delete it and add the table to the data model again. You'll also have to re-create any relationships and edit measures that referenced it. If you're lucky and keep the names identical the measures might self repair once you've created the new table and relationships.
Mynda
