AD as datasource - event log data

[Tsanka]

Hi guys,

Is there a way one to get the AD events  using the AD connector in Power BI?

Thanks

Tsanka

[v-yuezhe-msft]

@Tsanka,

The Active Directory connector returns information about Users, Accounts, and Computers. How do you configure AD event log? Is there any possibility that you export the log into a file? You can connect to the file in Power BI Desktop to analyze the log.

Regards,
Lydia

[Tsanka]

Hi @v-yuezhe-msft

Thanks for the response. 

Using PowerShell one can extract log information from the Active Directory. I was very much hoping this to be available through the AD connector and spent quite a lot of time in opening and looking at the exposed AD entities. I was hoping I was missing something and the log information was there (expected to see it limited for a period). 

Obviously it is not available and now I have to write powershell scripts, have to make SSIS packages to store the extracted CSV files somewhere, etc. Well, could be different, but life is not perfect.

Thanka again

Tsanka

[v-yuezhe-msft]

@Tsanka,

Yes. The built-in AD connector doesn't contain the log information. You would need to connect to the extracted log file in Power BI.

Regards,
Lydia