Export Facebook Public Data to Power BI

Connect Facebook Public Data to Power BI by following three simple steps:

Step 1: Collect data
First, connect your Facebook account. Next, enter a list of page IDs or public aliases from where you'd like to fetch data and select the type of report you wish to export.



After that, proceed to the next step.

Step 2: Organize and transform
Before you load Facebook Public Data to Power BI, check whether your data is accurate. If you need to make some data transformations, here's what you can do:

• Edit, rearrange, hide, or add columns.
• Apply various filters and sort your data.
• Create new columns with custom formulas.
• Combine data from multiple accounts or apps.

This way, you can proceed to analytics right after importing your data without any further adjustments.

Once you're done with that, move on to set up your destination.

Step 3: Load and automate
To import data from Facebook Public Data to Power BI, follow the in-app instructions to generate the integration URL and paste it into the Power BI desktop application.



After that, go back to Coupler.io to set up an automated data refresh. The final step is to save and run the importer.

To ensure your imported data remains relevant, use the automated refresh feature. Choose the update frequency to meet your requirements – ranging from monthly, daily, and hourly to intervals as frequent as every 15 or 30 minutes. You can also select specific days of the week, the preferred time slot, and the time zone to maximize customization.



Thanks to this functionality, your report will keep up with the ever-updating source data.