Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |