Forum Discussion
Steps to perform after refreshing data
In my report I import records with a start- and end date and a key_field.
From that table I create using dax a new table , with a record for each key_field and month between start and end date.
When that table is created I want to add fields from other tables with a calculated field for say events on a particular date giving a value of 1 to key_field and month of that event. Once that's done, the event table should be deleted (or emptied) to avoid having too much data in my report.
What I can't figure out is how to do all these steps automatically in the correct order when refreshing data
Hi noobtopowerbi ,
You cannot delete your event table. If you delete it, the calculated table created with DAX will report an error.
For example, it will display the error: "Cannot find table 'TableName'".
If you want to optimize the refresh, you can deselect the following option which is "Include in report refresh".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi noobtopowerbi ,
You cannot delete your event table. If you delete it, the calculated table created with DAX will report an error.
For example, it will display the error: "Cannot find table 'TableName'".
If you want to optimize the refresh, you can deselect the following option which is "Include in report refresh".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.