How can we improve Power BI?

Facebook Ads

170 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

AdminAdam Wilson (POWER BI) (Product Manager, Microsoft Power BI) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • Bruno commented  ·   ·  Flag as inappropriate

    Hello, my company's marketing department needs to analyze the Facebook ads data and the connector in Power BI would be very helpful. Are you going to have this option in brief?

    Thank you

  • Taryn Myers commented  ·   ·  Flag as inappropriate

    This, along with other non-existent data connectors are a must for marketing professionals. Marketing is a huge user group that I feel has been completely neglected. The only direct connect that exists in BI is Google Analytics. None of the other data sources are readily available. And we keep just finding work-arounds that the average person without M language or other language experience are just lost on. Please, can we get some of our marketing data sources connected!

  • Lionel commented  ·   ·  Flag as inappropriate

    I really want use more power BI but how is possible that an app from microsoft don't even have possibility to get data from facebook ads or business manager ? :( I hope we don't have to wait 10 years....

  • QS commented  ·   ·  Flag as inappropriate

    As a Power BI users I just wanted to share my work bottleneck with you. Hope you can help out with that.

  • Dan commented  ·   ·  Flag as inappropriate

    Did BI ever give a status on this or has anyone heard anything? It is important and used by many companies so we need this connectivity.

  • Thomas commented  ·   ·  Flag as inappropriate

    I agree, the need for a facebook marketing api (facebook ads) connector is really urgent!

  • michael austin commented  ·   ·  Flag as inappropriate

    I agree with adding connectivity for Facebook Ad Manager. Today's social media marketing analytics is MUCH more than likes and comments. I'll also add the request for 'status' of this feature? How come sites (like we are currently using) like have Facebook Ad Manager connectivity and Microsoft does not?

    I'd like to move our analytics to Power BI but can't get the Facebook Ad Manager piece which really decreases the value of Power BI.

  • Rick Hardy commented  ·   ·  Flag as inappropriate

    This is also important for my project, one important user group is unlikely to support Power BI as our solution if they cant connect all the necessary data sources.

  • Steve Ryan commented  ·   ·  Flag as inappropriate

    A trick I cURL for windows with https support. Use cURL from the cmd of your windows machine to download various insights from campaigns, ad sets and ads.


    You can get conversion data by either when the impression occurred or when the conversion occurred. For example, if a person saw the ad on Jan 1st but converted on Jan 2nd, when you query the API with action_report_time=impression, you see a conversion on Jan 1st. When you query the API with action_report_time=conversion, you see a conversion on Jan 2nd.

    curl -G
    -d 'action_report_time=conversion'
    -d 'access_token=<ACCESS_TOKEN>'<CAMPAIGN_ID>/insights
    - O <filename>.csv

    #Then upload the CSV to BI.

  • Jannis Busch commented  ·   ·  Flag as inappropriate

    This is really important and should be quickly done for the power bi team. Please give me the opportunity to connect to facebook ads api so i dont have to manually download the excel files

  • Khuram Malik commented  ·   ·  Flag as inappropriate

    Hi is there any news on this? I'd love to be able to download Facebook Ads data and analyse it in BI

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.