Facebook Power BI Report 04-08-2016 13:23 PM

[Mykhael]

Facebook is one of the most important channels on social media for to many companies. But handle all the Data that Facebook give you by its API is very hard and sometimes confusing, but in this interactive report I will show you another way to see Facebook Insights using a clear and simple but strong design to help you see if your marketing efforts are going well. This is just one of another 7 reports I designed for Facebook, Twitter, Pinterest, Youtube and Instagram on Power BI. But Colors, Shapes and Charts is just one part of this report, behind you will see Power query data modeling, DAX formulas, relationships etc. I hope you enjoy it.

Learn more about this report from the author by watching this video: https://www.youtube.com/watch?v=C2z-hj3J_Bs

 

eyJrIjoiYzlkYTE1YTAtY2RlMS00YWQ0LThlZDMtZTdiZmVlYmViNDY0IiwidCI6IjU3NGMzZTU2LTQ5MjQtNDAwNC1hZDFhLWQ4NDI3ZTdkYjI0MSIsImMiOjZ9

[chonox]

Hi Mykhael!

Thanks for the comment! So the FB connector got improved? Ive been trying to use it since long time ago and had several issues. Are you able to connect to a fan page and get the feed connection? I am using it right now, and keep getting an error "Facebook: An unknown error occurred" . How are you using it that works so well for you? 

Thanks !!

[Mykhael]

Hi @chonox

The FB connector didn't improved, still the same, but we can get feed connection and everything, I suggest you to stay watching my post and tweets, very soon I will show all we can do using the FB connector, but if you really need assistence please contact me by Skype, and I can show you what I am doing. mmyers@redwaves.onmicrosoft.com    Twitter: @myersmiguel

Greetings

[Chrismtz]

I would like to know if you have a video or a material that you recommend me to work with the Facebook connector or how you do it to get the very good Dashboard data. regards

[chonox]

Thanks @Mykhael ! Can't wait for that post. Excellent work with Cheetos, looking forward building social media data for brands!

[Mykhael]

Hello @chonox,

What you are assuming is correct!!! This particular report is connected directly to the Facebook API, and works LIVE, that means the information always change and get refreshed... The API send the data to my server in different tables (I use Azure) and then I use Power BI to manipulate and enhance my queries. About the Facebook connector you are talking about... In my experience is terrible, I don't think you can get a good report from that one... Maybe in the future they will improve it but right now it is very hard to use it.

Best

[jajatibadu]

Hi @Mykhael

Thanks a for a great Post.. I am just curious to know how FB api sends data to your azure tables? Is it on real time or you have some job which pull records from FB and load in DB at some scheduled time ?

J

[jajatibadu]

Hi @Mykhael

Thanks a for a great Post.. I am just curious to know how FB api sends data to your azure tables? Is it on real time or you have some job which pull records from FB and load in DB at some scheduled time ?

J