Mykhael's avatar
Mykhael
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

Facebook Power BI Report

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 inter...
Social Media
tanckc's avatar
tanckc
Regular Visitor
10 years ago

Hey Mykhael

 

great work - how do you get he rounded edges on your charts and cards?

 

Best - [email protected]

Mykhael's avatar
Mykhael
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago
Hi tanckc,
The trick is very simple, those rounded squares are just that.... 1. Select shapes from the top panel. 2. Choose the square shape. 3. Select edit from the right panel (the icon is a little yellow pencil) 4. Go to General. 5. Change the rounded number. And that's it. You can change the line and shape color as well. Then you can overlay a chart or card to create the effect... If this answer helped you please give me a like and mark this answer as solution to help others. If you are interested in more tricks like this I invite you to check my posts here into the showcases, or you can email me and I can invite you in one of the conferences I speak about designing Power Bi reports. [email protected]
Best
  • chonox's avatar
    chonox
    Frequent Visitor
    10 years ago

    Hi Mykhael, congrats on that spectacular FB report!

    Iam assuming that you are not using the FB connector on the power bi sources, right? Are you using fb page stats and loading it to a Database? Is it possible using power bi connector to build a report similar to yours?

     

    Thanks! 

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago
      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's avatar
        jajatibadu
        New Member
        9 years ago

        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

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago

      Hello chonox,

       

      My apologize, I remember I told you the FB connector is not good enough to creat a good report around Facebook Insights. I was totally wrong, you can create a better report than this one using the FB connector, How do I know that?, because I am working right now using it, and I can tell you... It's AMAZING!!!, So I change my answer...

       

      The answer is YES you can, and BETTER than this.

       

      Best

      Miguel

      • chonox's avatar
        chonox
        Frequent Visitor
        10 years ago

        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 !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    I tried this. But I am not able to see any option for rounded number. I can only see X Position, Y Position, Width, Height.

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago

      Hi Anonymous,

       

      It is very easy, let me explain you.

       

      1. Select the shape

      2. Go to the Format Shape Panel (it's in your right)

      3. Select "Line"

      4. change the "Round Edges" Percentage

       

      That's it...

       

      I hope this helped you, anything else let me know OK?

      • SKM_Data's avatar
        SKM_Data
        Icon for Advocate II rankAdvocate II
        10 years ago

        Hey Mykhael,

         

        Congrats on a really beautiful report.  I love the 1 to 20 navigation pane that you set up at the bottom of the report/dashboard and was wondering how you accomplished that.  It's a really effective way to tell a story with data and I'd love to be able to use it too.

         

        Thanks,

        Sean