Forum Discussion

HSF's avatar
HSF
New Member
9 years ago
Solved

Yammer

Can someone guide me how to extract data from Yammer at regular interval and create Power BI Dashboard and Reports from this data?
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    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

                      export yammer data

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

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

                  export yammer data

 

Best regards,
Yuliana Gu

hasancakir's avatar
hasancakir
New Member
6 years ago

v-yulgu-msft 

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;

  1. Why do we need to use third party tools like tyGraph(still in beta) while yammer is an office 365 feature? Microsoft should provide a connector for yammer.
  2. The other solution you provide is to use csv file. But, yammer is a real time application and we will not check the report for one time. Report also should be real time also we can not export csv file everytime.

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.