Forum Discussion

timcorke's avatar
timcorke
Helper I
4 years ago

Creating new datasource from Exchange mailbox

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

 

 

 

2 Replies