Synching Python script and Microsoft Exchange

[talesgadelha]

Hi, 

I'm new in PBi. I'm trying to use my mailbox to control the answered e-mails and high priority flags in my inbox. 

I set the Exchange as data source and synch my mailbox. Worked fine.

So, in the next step, i tried to write a python script and use this 'dataset'.

I tried about 3 different ways to declare the dataset, but always return a error.

How can i replace the "pd.read_excel(r'<put your path here>')" with a comand to use the "Mail" (Exchange data source result) ?

[talesgadelha]

Hi everyone.,

As i said, i'm a liitle bit new in power bi,

My problem was solved by opening the power query and selecting the hidden atributes.

Bye

[v-jingzhang · Accepted solution]

Hi @talesgadelha 

What do you want to use Python to do about the mailbox result? If you want to transform and shape the data, you can use Power Query Editor to do that. It is very powerful. 

If you only want to use Exchange connector to get the mailbox data and have it for other use, you can export the data into an Excel or CSV file, then use it with Python. With DAX Studio's Export Data feature, it's very easy.

DAX Tools - DAX Studio 15 – Export data - YouTube

Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods ...

Let me know if you have other concerns.

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