Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am pretty new to Power BI, and I am unsure if I can achieve what I need.
I want to run the below power shell script daily.
$GroupId=XXXXX
$Token = "XXXXX"
$Headers = @{ "Authorization" = "Bearer "+$Token }
$GroupCycle = 1
DO
{
$GetMoreGroupsUri = "https://www.yammer.com/api/v1/users/in_group/$GroupId.xml?page=$GroupCycle"
write-host ("REST API CALL : $GetMoreGroupsUri")
[xml]$Xml = ((Invoke-WebRequest -Uri $GetMoreGroupsUri -Method Get -Headers $Headers).content)
$YammerGroups += $Xml.response.users.user
$GroupCycle ++
$GroupCount += $Xml.response.users.user.count
write-host ("GROUPMEMBER COUNT : $GroupCount")
}
While ($Xml.response.users.user.count -gt 0)
$YammerGroups | Where {$_} | Export-Csv "$GroupId.csv" -Delimiter ","
I found this script on this website:
I can execute it manually(without power bi), but I would like to know if I can run it thanks to power bi and automate it.
I would appreciate all your help.
Solved! Go to Solution.
Hi @V-lianl-msft,
Thank you for your help. I actually checked with them but it was quite expensive comparing what I really needed.
I was able to automate it by making an API call on the Alteryx server.
I am not very familiar with Power BI but propably I could automate this somehow with power automate and or Power BI.
Long story short thank you for your help but I finally achieved what I wanted.
Hi @V-lianl-msft,
Thank you for your help. I actually checked with them but it was quite expensive comparing what I really needed.
I was able to automate it by making an API call on the Alteryx server.
I am not very familiar with Power BI but propably I could automate this somehow with power automate and or Power BI.
Long story short thank you for your help but I finally achieved what I wanted.
You can try tyGraph, which makes it easy for you to connect to Yammer so that you can export data from the dashboard.If you want to export automatically, see if this article will help:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export
Any suggestion would be highly appreciated.