Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
7 years ago

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Tsanka
      Kudo Collector
      7 years ago

      Hi Anonymous

       

      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

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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