Forum Discussion
Yammer Question
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.
- Anonymous4 years ago
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.
3 Replies
- V-lianl-msftCommunity Support
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
- AnonymousNot applicable
Any suggestion would be highly appreciated.
- AnonymousNot applicable
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.