cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tsanka
Continued Contributor
Continued Contributor

AD as datasource - event log data

Hi guys,

 

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

 

Thanks

Tsanka

3 REPLIES 3
v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tsanka
Continued Contributor
Continued Contributor

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

 

 

 

@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

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors