PowerBI | AD | Query

[Anonymous]

Hello,

I trying to build a compliance that checks one table with another and let know the difference. One of my table is from AV product which I was able to fetch to PowerBI.

However the other one is AD. I am aware of AD integrating with PowerBI, but there are numerous tables scattered throughout the AD, and I am unable to map it for my requirement.

Currently I am achieving through Powershell query and export to csv and then compare. 

Get-ADComputer -Filter * -Property * | Format-Table Name,OperatingSystem,IPv4Address,Description -Wrap -Auto

Is there anyway that I can make use of PowerBI to get an automated updated data? 

[v-henryk-mstf]

Hi @Anonymous ,

You can update your data automatically set by configuring scheduled refresh. If your data set is too large and the refresh time is too long each time, you can choose incremental refresh.

Refer to the following official documents: 

Data refresh in Power BI - Power BI | Microsoft Docs

Configure incremental refresh for Power BI datasets - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I am not looking for refresh exactly.

I wish to know how to query powershell command in PowerBI and extract to a table and process the data.

[v-henryk-mstf]

Hi @Anonymous ,

Check if the following documents can help you.😊

Exporting Data with PowerShell – SQLServerCentral

6 methods to write PowerShell output to a SQL Server table (sqlshack.com)

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.