Power BI Connector for Instagram

Build 25.0.9454

MediaInsightsPostAlbum

Offers comprehensive analytics for individual carousel album posts shared on Instagram. It includes metrics such as reach, engagement, and saves. To access this information, the application must have the instagram_basic and instagram_manage_insights OAuth scopes, which allow it to retrieve performance data for content posted by the user.

Select

You can query the following metrics using server-side processing:

  • TotalInteractions
The connector will use the Instagram APIs to process filters by a MediaId and will process filters on other columns client-side within itself.

  • Return results for the following metrics, saved for all the POSTs carousel album objects: TotalInteractions.
         SELECT * FROM MediaInsightsPostAlbum WHERE MediaId = 17945732813652602"
    
         SELECT TotalInteractions FROM MediaInsightsPostAlbum WHERE MediaId = 17945732813652602 
    
        

Columns

Name Type Description
MediaId String The unique identifier assigned to each media insight record. This ID is used to link the insight data to a specific post within the album and ensures traceability across datasets.
TotalInteractions Integer The aggregate number of user engagement actions related to the album post, including likes, saves, comments, and shares. This total excludes negative actions such as unlikes, unsaves, and deleted comments to reflect net positive interaction.
Views Integer The cumulative count of how many times the album post was displayed to users. This metric includes repeated views by the same user and reflects overall visibility or exposure.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454