hugoberry / facebookads

FacebookAds PowerBI data connector

FacebooksAds PowerBI data connector

PwerBI data connector for FacevookAds

Quickstart

This module uses the extensibility provided by Data Connectors, so in order to use it you have to:

1. Create a [My Documents]\Microsoft Power BI Desktop\Custom Connectors directory
2. Enable the Custom data connectors preview feature in Power BI Desktop (under File | Options and settings | Custom data connectors)
3. Copy the the *.mez file from /build folder into the above folder
4. Restart Power BI Desktop

For developers

In order to extend the modules

1. Install the Power Query SDK from the Visual Studio Marketplace
2. Edit the existing Data Connector Project or *.pq files
3. Build the solution The deployable *.mez files will be located in the Debug folder of each module under /src. The Relese configuration of the build will copy these files into the /build folder.

Functions

For additional examples and documentation please refer to the embeded documentation of each of the functions.

FacebookAds.Campaign

A function that returns statistical insights related to the campaigns associated with connected user

FacebookAds.Campaigns()

Output

FacebookAds.API

Return a function which always returns a given value.

FacebookAds.API(URI as URI.Type, params as record)

Example FacebookAds.API("/me/adaccounts",[fields="name"])[data]{0}

facebookads's Issues

Authentication doesn't seem to be picked up

I just authenticated with my personal account which is an admin of the ads account but I get
Details: "Access to the resource is forbidden." when trying to set up FacebookAds datasource. Am i missing something ?

Expression.Error: The field 'name' of the record wasn't found.

Hello, after 02/02/2020 when requesting data update this error occurs:

Expression.Error: The field 'name' of the record wasn't found.
Details:
has_error=TRUE
error_value=[Record]
error_reason=DataSource.Error
error_message=Web.Contents failed to get contents from 'https://graph.facebook.com/v3.2/me/adaccounts

When trying to create a new connection, do not load the options in this step:

Connector not working

Hello,
Thank you very much for this connector. I'm not able to load my ads account.
I have this error :

DataSource.Error : Web.Contents n'a pas réussi à obtenir le contenu de « https://graph.facebook.com/v2.11/act_10211012471928721/campaigns?access_token=EAAdAzsVjmowBAARjeJfVd1ZCOaJ5TN4YF0naAESUZBKkhet2Hq81LjZC0bkOpu8aAqF1zo2AjmI7ZCPoU48ZC2L7JyeHqDadblUHDrHP9xFFZCjixZCZANI2q55QRd16FZBAml9C983rIaJoC8EUSIyDSrOJ8bRStRw5ZBdIa1fZAPdvgZDZD&fields=name » (400) : Bad Request
Détails :
    DataSourceKind=FacebookAds
    DataSourcePath=FacebookAds
    Url=https://graph.facebook.com/v2.11/act_10211012471928721/campaigns?access_token=EAAdAzsVjmowBAARjeJfVd1ZCOaJ5TN4YF0naAESUZBKkhet2Hq81LjZC0bkOpu8aAqF1zo2AjmI7ZCPoU48ZC2L7JyeHqDadblUHDrHP9xFFZCjixZCZANI2q55QRd16FZBAml9C983rIaJoC8EUSIyDSrOJ8bRStRw5ZBdIa1fZAPdvgZDZD&fields=name

It's in french but it says Web.Contents failed to obtain the content of ....
Thank you for your help, I hope you will be able to solve this. It would be so great if the connector could work ! :D