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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors