Export data from Power Bi

Heather2019 · ‎05-23-2018

Dear Sirs,

I would like to ask a couple of questions:

- Could I export data from the Exchange Oneline - User activity for instance to Excel automatically? I mean I would like to export the data automatically to a dynamic table or to charts. (And would like to avoid monthly formatting and manipulation). Is it possible and how do we this? powershell?

- In my report, the locationcountry attribute displays the countries with the ISO code instead of the full country name. Can we ask Office 365 to interpret these codes so that the countries are displayed completely?

- In my report and then export, I noticed that we have all the admin accounts. How can we exclude these accounts before exporting the data to excel?

Thank you for your help, I begin with PI 😉

v-yulgu-msft · ‎05-24-2018

Hi @Heather2019,

Could I export data from the Exchange Oneline - User activity for instance to Excel automatically? I mean I would like to export the data automatically to a dynamic table or to charts. (And would like to avoid monthly formatting and manipulation). Is it possible and how do we this? powershell?

It looks like this question is more related to Exchange.

In my report, the locationcountry attribute displays the countries with the ISO code instead of the full country name. Can we ask Office 365 to interpret these codes so that the countries are displayed completely?

Is the report you mentioned here a Power BI report? I don't think Power BI report can interpret codes to full country names automatically.

In my report and then export, I noticed that we have all the admin accounts. How can we exclude these accounts before exporting the data to excel?

Please illustrate your question with more details.

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Heather2019 · ‎05-24-2018

Hi Yuliana

I am really speaking about Power BI Pro / Content Pack which i consult online.

In this content pack you have many reports available, one concerns "Exchange online - user activity" as shown below and contains graphs and a table with all the detailed data for this report (UPN, EXO_TotalofAllActivities). You can export these data to excel (xlsx or .csv). then I have to format the data. My question is if i decide to format the data with a dynamic table or a graph is it possible to have automatic updates on the monthly basis on the same excel (monthly basis = when MCS has updated the report) ?

When you export the data to excel, you export all the properties of your report, like the UPN, I just want to exclude the admin accounts present in the UPN column because they spoil my result. is it possible to do this?

Thank you