Tables
The connector models the data in WordPress as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for WordPress Tables
| Name | Description |
| Categories | Returns information about WordPress categories, including their names, descriptions, and post counts. |
| Comments | Returns comments from WordPress posts, including author details, content, and status information. |
| Media | Create, update, delete, and query Media to attach in your posts. |
| Members | Create, update, delete, and list the Members of the website. |
| Pages | Create, update, delete, and query Wordpress Pages. |
| Plugins | Create, update, delete, and query Plugins. |
| Posts | Create, update, delete, and query Wordpress Posts. |
| Tags | Create, update, delete, and query Tags to associate with your posts. |
| Users | Create, update, delete, and list the Users of the website. |