topic Re: Yammer Question in Developer

Yammer Question

Anonymous — Mon, 04 Oct 2021 09:24:01 GMT

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

{

$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-42c3-9247-79e79f92b535

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.

Re: Yammer Question

Anonymous — Tue, 05 Oct 2021 09:38:06 GMT

Any suggestion would be highly appreciated.

Re: Yammer Question

V-lianl-msft — Thu, 07 Oct 2021 01:55:45 GMT

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

Re: Yammer Question

Anonymous — Thu, 07 Oct 2021 08:20:16 GMT

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.