Good morning community!
We now have new requirements in the corporation, which makes data protection regulations a little stricter.
This means that executives are only allowed to receive data, which is also assigned to the area.
Previously, the records were exported from an Access database as a single Excel file.
PowerQuery was referenced to this file to always have the most recent records.
Now you have to filter in Access per area and export it back to an Excel file. That means there will be 10 files in the end, one for each area.
Now I would like to somehow simplify or automate this.
What options do I have for this?
I have to make sure that each area really only gets its own data 100%.
Do you have any ideas?
Best regards
Joshua
We now have new requirements in the corporation, which makes data protection regulations a little stricter.
This means that executives are only allowed to receive data, which is also assigned to the area.
Previously, the records were exported from an Access database as a single Excel file.
PowerQuery was referenced to this file to always have the most recent records.
Now you have to filter in Access per area and export it back to an Excel file. That means there will be 10 files in the end, one for each area.
Now I would like to somehow simplify or automate this.
What options do I have for this?
I have to make sure that each area really only gets its own data 100%.
Do you have any ideas?
Best regards
Joshua