cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SuperKhazd0rf Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

I'm getting "Column1" not found using this custom connector 😞

saisatya Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

Expression.Error: The column 'Column1' of the table wasn't found.
Details:
Column1

MarianneElver Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Hi, right now this is due to a limit of FB accounts allowed to use this connector. An increased limit is expected soon. I'll update this thread when the use of the connector is possible again for more users.

Frankie Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

Hello guys,

I've been following this topic from the beginning but I can´t get to connect both platforms in any way. Is there any update? I've tried as v 2.10 but neither. Can anyone give me any light about to solve the problem?

Thanks in advance

Frankie Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

Hello guys,

I've been following this topic from the beginning but I can´t get to connect both platforms in any way. Is there any update? I've tried as v 2.10 but neither. Can anyone give me any light about to solve the problem?

Thanks in advance

echofoxtrot Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Hey @Frankie,

 

If you open Power BI Desktop and select a new data source of Web, and use the URL below (replacing "youraccountid" with a Facebook Account ID that's tied in with you Facebook API, and replace "youraccesstoken" with your up to date Facebook Access token), it should connect:

 

https://graph.facebook.com/v2.12/act_youraccountid/insights?access_token=youraccesstoken&limit=10000...

 

Then you'll just need to expand the list in the Query results, etc.

 

Within Facebook, you need to make sure your Facebook app is updated to the latest API version (currently at 2.12 or higher. See attached screenshot).

 

In the Facebook API setting, make sure your Facebook Ad Account ID is tied in with that App (you can check this and add it in your Facebook App under Advanced Settings).

 

If that's good to go, then within the Facebook App, go to the "Marketing API" - Tools - and generate a new Access Token that has "read_insights" and "ads_read". That should give you the Access Token you need.

 

Good luck and lmk.

 

 

FB API Version.jpgFB API Account ID.jpgPBI New Data Source - Web.jpgQuery.jpg

dimitrischo Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

Hi to all i am using this moment the connector 

https://try.scitylana.com/pbi-connector-gallery

 

But although it appears only 25 pages while i have more than 100+ pages. 

 

Does anyone know why this happens? is there any limitation?

 

michaelbilling Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Maybe you aree using an other version of the connector?

Have you tried the latest version?

 

If you still have problems, contact Scitylana support, support at scitylana dot com

Cheers,

Michael

michaelbilling Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Maybe you aree using an other version of the connector?

Have you tried the latest version?

 

If you still have problems, contact Scitylana support, support at scitylana dot com

Cheers,

Michael

hermesgoddess Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

Hi, I just tried to use the Connector and received a couple of errors depending on which Ad Account dataset I tried to pull. 

 

If I try to connect to a Facebook All Ads Insights, I just get all null fields in my table (there is plenty of data in this Ad Account)

If I try to connect to Facebook Ad Actions, I get the log, DataSource.Error: Web.Contents failed to get contents from .... (400):Bad Request

If I try to connect to Facebook Active Ad Insights, I get Expression.Error: The column 'column1' of the table wasn't found. 

 

I wrote to the support email you provided in your post. Will wait to hear back. 

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,215)