Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
7 years ago

Microsoft Exchange Issue

Hello All, I have been trying to think of a solution for a issue that I am currently running into and would like to see if anyone has tried this before. I have a PBI report which uses the Microsoft Ex...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi nirvana_moksh,

 

My bad. I didn't make it clear. It's exactly what have done. Retrieve all the emails to a SQL database then connect to it from the Desktop. You can filter the email before you dump them into the DB. 

Because the "Navigation" process doesn't provide a filter function. So we load all the previews and then filter them. It's a preview of data in the Query Editor. It's fine to load the whole data. You can give it a try anyway.

 

 

Best Regards,
Dale

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
7 years ago

v-jiascu-msft- I was thinking of doing the same using SSIS, but SSIS does not have a direct connector to connect to these Mailboxes, so I came across Microsoft Graph API, would you be able to suggest more on what will be the correct way? Maybe using Graph API in conjunction with SQL DB and Power BI?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi nirvana_moksh,

     

    After surfing the graph/overview, I find the Graph API is the bridge between the emails and the SQL DB. Power BI can work directly with SQL DB. So the process could be as follows. 

    1. Fetch emails with Graph API and store in a SQL DB. Filter the emails if possible. 

    2. Connect to the SQL DB from Power BI. 

     

    Best Regards,
    Dale