Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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:

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. 

  • Anonymous's avatar
    Anonymous
    4 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Any suggestion would be highly appreciated.

  • Anonymous's avatar
    Anonymous
    Not 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.