Create new row in dataset during facebook refresh

[markpendlebury]

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

[Anonymous]

@markpendlebury,

Power BI will not automatically create new row during refresh, there is an idea about loading just new or changed rows from source system, please vote it up.

Meanwhile, you can use the workaround in the blog below to create historical table in Power BI Desktop.
http://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-...

Regards,
Lydia