October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Can someone guide me how to extract data from Yammer at regular interval and create Power BI Dashboard and Reports from this data?
Solved! Go to Solution.
Hi @HSF,
Power BI desktop supports tyGraph connector that allows users to get data from Yammer.
Alternatively, you can visualize and explore your tyGraph data in Power BI service with the Power BI content pack. Start by connecting to your tyGraph account and loading the dashboard, reports and dataset. For details, please see: tyGraph content pack for Power BI
Besides, you can export Yammer data to .csv file, then, load data from csv file to Power BI desktop.
Reference: Yammer Analytics with Excel and Power BI
Best regards,
Yuliana Gu
Hi @HSF,
Power BI desktop supports tyGraph connector that allows users to get data from Yammer.
Alternatively, you can visualize and explore your tyGraph data in Power BI service with the Power BI content pack. Start by connecting to your tyGraph account and loading the dashboard, reports and dataset. For details, please see: tyGraph content pack for Power BI
Besides, you can export Yammer data to .csv file, then, load data from csv file to Power BI desktop.
Reference: Yammer Analytics with Excel and Power BI
Best regards,
Yuliana Gu
We are using all office 365 tools(sharepoont online, power bi, yammer,ms words,ms teams,power apps, ms flows outlooks etc.) in my company in order to be sure everything is integrated properly. Honestly, I can not understand why do we need to make that much workaround for creating power bi reports with yammer data.
Please consider my below comments;
As a workaround, I am using yammer api with a token. It is working properly in power bi desktop. But after I publish my report in power bi online, I am getting this error 'Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.' in data source credentials. Therefore, I could not set up 'Scheduled Refresh'.
As a last option, I will create my custom api gateway which connects Yammer APIs. But, I would like to know before implementing this workaround, If there is a more proper solution.
tyGraph is not for free and two other ways suggested are more or less not efficent enough to get them automated with Power BI.
People / companies can create all Yammer based cool dashboards on their own. Just make it possible to directly connect n automate the Yammer feed extraction in PowerBI. It's a pity we can connect to Facebook, SalesForce n what not from PowerBI directly but not to Yammer. 😞
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |