Forum Discussion

markpendlebury's avatar
markpendlebury
Frequent Visitor
9 years ago

Create new row in dataset during facebook refresh

HI everyone, I hope someone can help me.

 

I'm using the Facebook API connector to pull in the number of fan likes for our business page. I've managed to get the date I need (it's not offered as a default) by using the graph explorer to get to the right data and then modifying the connection string.

 

This gets around the FB access token issue if I did it myself without the existing FB Integration as the App refreshes the token ID.

 

Anyway, my datasource is now ;

 

= Facebook.Graph("https://graph.facebook.com/v2.8/pagename/?fields=fan_count")

 

Which returns a nice refreshable table of ;

 

fan_count, Date 

201611, Timestamp (calculated column using NOW() )

 

Upon refresh this data gets updated.....

 

Is it possible to create a new row per refresh instead so I can track the number of fans over time? 

 

The long way around this would be to use the Facebook API seperately, do the heavy lifting and then create an sql table with a row per request as the Power BI datasource but I'm hoping I can get Power BI to do it for me instead?

 

Thanks