Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Power BI Connector for Facebook Views
| Name | Description |
| Comments | Create, update, delete, and query the Comments for a Target. Comments may also be inserted based on a Target or deleted based on Id. |
| Events | Query the Events for a Target such as a page id. |
| InsightsByConsumptionType | Allows retrieval of insights by consumption type. |
| InsightsByFeedbackType | Allows retrieval of insights by feedback type. |
| InsightsByLikeSourceType | Allows retrieval of insights by like source type. |
| InsightsByReactionTotals | Allows retrieval of insights by like source type. |
| InsightsByStoryType | Allows retrieval of insights by like story type. |
| InsightsByTabType | Allows retrieval of insights by tab type.. |
| InsightsByUnLikeSourceType | Allows retrieval of insights by like source type. |
| InstagramAccountInsights | Allows you to get insights for an Instagram Business Account. Requires the instagram_basic and instagram_manage_insights scopes. |
| PageAndPostInsights | Allows the retrieval of simple insights with a single value in the response. |
| PageLiveVideos | Live videos on a specified page. This table requires authentication, and the pages_read_engagement (or Page Public Content Access feature if you cannot moderate the page) and pages_show_list permissions. The Page Id must be specified as the Target. |
| Pages | Query the Pages based on the supplied Id. |
| Permissions | Query the Permissions the User has granted the current application. |
| Photos | Query Photos associated with a Target. Accessing Photo information typically requires the user_photos permission. |
| Places | Query the Places based on the supplied Id. Places are stored as Pages in Facebook. |
| PostSponsorTags | Query the Pages that have sponsored a target post. This table requires authentication, and the Post Id must be specified as the Target. |
| Ratings | List of ratings for a Facebook Page. This view requires authentication. |
| SimpleVideoInsights | Allows the retrieval of simple video insights with a single value in the response. |
| StoryAttachments | Query attachments from a post or comment. |
| TaggedBy | Query information about Posts, Statuses, Photos, and other entities that have tagged the User or Page. This view is a derivative of the Wall connection where only entries that have tagged the Target User or Page will be returned. In general it is only available for Pages. |
| Users | Returns basic information about the authenticated user. |
| VideoInsightsByActionType | Allows the retrieval of video insights by story action type. |
| VideoInsightsByDistributionType | Allows the retrieval of video insights by distribution type. |
| VideoInsightsByReactionType | Allows the retrieval of video insights by reaction type. |
| VideoReels | Query reels for a given page. |
| Videos | Query Videos from a Target. Normally requires the user_videos permission. |
| Wall | Query Posts from the Wall of a Target. |