Forum Discussion
PowerBI | AD | Query
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?
3 Replies
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.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,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
