Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Bakhtawar
Post Patron
Post Patron

Fan page count by date / time wise power bi

I am trying to get data from facebook and display total likes which is on facebook page i.e fan_count .. i got this fan_count from facebook page but now i want this fan_count by date/time wise so how i get date_time from respective facebook page because user may able to see in which month how many likes facebook page gets.. i have this file check please https://www.dropbox.com/s/9uis5fmw5hocl01/fan_count.pbix?dl=0

3 REPLIES 3
TeigeGao
Solution Sage
Solution Sage

Hi @Bakhtawar ,

The detailed record should stores in the [Record] in connections, we will need to expand the data.

PBIDesktop_wWW5AdNj9A.png

Because I cannot access your data source, I can only share the example to expand the data:

First, we need to go to Power Query, we can click the edit queries, then we will see expand icon (e46f02a2-febb-424c-8b23-64991ef9cba1.png) in the column header. Click the expand button, it will expand the detailed information.

Best Regards,

Teige

@TeigeGao  yes i expand that but i only find feed , likes and post .. and in post i find connections.post.createdate.. 

but here i think that createddate is belong to posts ? 

Bakhtawar
Post Patron
Post Patron

any help please

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.