Create a facebook dashboard for Power BI

This require Power BI experience, DAX and "M" language knowledge. Dashboard should show facebook data from specific facebook page. The task is: 1. Create a re-usable connection in "M" language for Power BI with Facebook API specified here: [login to view URL] Issue I have which need to be discussed before is refreshing API key. Resulted connection should be self refreshing API key or one time verify. I dont want to generate API key each refresh. 2. Extract required data. 3. Put data in Graphs. (no visual designing needed) ------------------------- 3. Put data in Graphs similar to attached image 1. graph - Table: (it will show scrolling table of latest posts) [Img of post] [Text] 2. graph - Card: Count page fans 3. graph - Card: Visits (i pull this data from google analytics, not needed) 4. graph - Card: Number of page posts in given time period 5. graph - Card: Total reactions in given time period (likes, comments etc...) 6. graph - Card: Reactions/number of posts (likes, comments etc...) 7. graph - Multi-row cards: Reactions divided by its subcategories (comments, likes ...) 8. graph - treemap: Total impressions divided by type (organic, paid..) 9. graph - donut chart: Percentage of users who were engaging in given time period and those who were not There might be a problem from data limit, read about that before. I will assist during task. Deadline is to wednesday 12. 7. 2017 have a finished pbix file. I delete every nonpersonalized offers mention at least Power BI. This can be used for testing: [login to view URL]