Creating new datasource from Exchange mailbox

[timcorke]

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

[timcorke]

Many thanks @v-jingzhang - I'll check this out and come back to you.

Apologies for the delay, just got back from holidays!

Tim

[v-jingzhang]

Hi @timcorke 

You can use Dax Studio to export table data from Power BI Desktop to CSV files or SQL Server databases. Then connect to these files/databases to get data for your report. 

Reference: 

GUIDE ON EXPORTING DATA FROM POWER BI (PBIX) FILE TO SQL SERVER 

Export Power Query Tables to CSV using DAX Studio. Even 5 Million records! 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.