Power BI allows you to use Google Sheets as a data source to create and share visual reports. You can combine multiple data sources to allow you to monitor campaign performance, assess the health of your customer relationships, and strategically plan your future marketing.
Available data
By connecting your Dotdigital account with Google Sheets, you can expose the following data for use in Power BI:
Integration | Available data |
Google Sheets: Contacts |
|
Google Sheets: Campaigns |
|
Google Sheets: Forms |
|
Before you start
Things you need to know:
The option to connect your Google Sheets data is only available in Power BI Desktop.
Power BI Desktop is a free application that runs on your local computer. You can download Power BI Desktop directly, or you can get it from the Microsoft Store.
You must have installed and set up the Google Sheets integration for the data you want to use in Power BI.
Connect Power BI
In Power BI Desktop, select Home and then select Get data.
In the Get Data window, search for and select Google Sheets.
Select Connect.
Enter the URL for the Google Sheet you want to connect, then select OK.
When prompted, select Sign in and enter the credentials for your Google Sheets account.
Once successfully authenticated, select the sheets you want to import and then select Connect.
Learn more
Use Microsoft’s documentation to learn more about:
Explore additional data export options in Dotdigital: