Yammer Question

[Anonymous]

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:

https://support.microsoft.com/en-us/office/export-yammer-group-members-to-a-csv-file-201a78fd-67b8-4...

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. 

[Anonymous · Accepted 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. 

[V-lianl-msft]

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 

[Anonymous]

Any suggestion would be highly appreciated.