Morning experts,
Looking for some guidance relating to Microsoft Exchange as a data source.
Currently I manage a shared mailbox Insight that receives notifications from our systems when a report doesn't complete, but I dont have a password to do anything with 'administrator' acccess. I have a rule set up that sends the notification to my own email and a separate folder Failed Notifications. I then connect PowerBI to my Exchange mailbox and do various PQ transformations on the received email to extract the data I need. This works well and am pleased with this.
However, the folder is getting larger and whilst it's not cause for immediate concern, I wondered whether there was a way of somehow lifting all the processed data from within PQ into a separate table that the report can then run from, to remove the need to keep all of these notifications?
Thanks as always,
Tim
