Download and use marketing analytics templates and sample reports for Power BI

This article provides a gallery with links to downloads and details for each Microsoft Power BI template and sample report that's currently available for Dynamics 365 Marketing. It also explains how to connect a downloaded template to your Dynamics 365 Marketing instance. These resources help you produce custom analytics reports with Power BI for your Dynamics 365 Marketing organization.

Tip

Download your marketing analytics reports and templates directly from our gallery—ready to use with Dynamics 365 Marketing!

Choose from a growing number of marketing reports for easy download, and find the information to help you select the reports that fit your needs. Each template and report provides useful views, charts, and analytics. You can use the standard features of the Power BI Desktop to explore the data sources and analytical displays, and customize them to meet your own organization's requirements.

Name Description Template Report
Generic template (framework and tools) This report provides generic parameters, data sources, and query code you can use to query for any marketing data from Microsoft Dataverse and the interaction store. Download template. Download sample report
Basic leaderboard report (journeys and email marketing) Identify your most effective journeys and marketing messages. Download template. Download sample report
Email marketing report Deep-dive into your email marketing plans, activities, and interactions. Download template. Download sample report
Segmentation report Analyze how segments are used in your marketing activities. Download template. Download sample report
Marketing program effectiveness Analyze the end-to-end effectiveness of your marketing programs, including automation, journeys, channels, lead generation, conversion, and revenue generation. Download template. Download sample report
Marketing reach analysis Identify contacts and how you're reaching out to them. See all audiences reached in selected journeys, together with their related interactions. Download template. Download sample report
Marketing form submission report Get an overview of the submission stream across all your marketing forms. Download template. Download sample report

The source code for all of these reports is available publicly on GitHub.

A collage of various Power BI reports.

Connect a Power BI template to your Dynamics 365 Marketing instance

After your Azure Blob storage is set up and connected to Dynamics 365 Marketing, you're ready to start working in Power BI to connect to your data sources and design your analytics.

  1. If you haven't done so already, download the templates you need from the gallery.

  2. Select a template and open it in Power BI Desktop. If you don't already have Power BI Desktop, you can download it for free from https://powerbi.microsoft.com/desktop/.

  3. The first time you open a Power BI template, you'll be asked to specify connection strings and credentials to connect to both Azure Blob storage and to Dynamics 365 Marketing.

    The connection dialog for connecting your Power BI template to the relevant data sources.

    • To connect to the Dynamics 365 database, use the same user credentials that you use to sign in to Marketing.
    • You can find connection details for your Azure Blob storage by using Azure Storage Explorer.
    • Specify how many days of interaction data that you want to load (counting back from today).
  4. Select Load to load the template into Power BI.

    Note

    If you see loading errors the first time you open a template, open the query editor, select a query that has been highlighted with a warning icon, and then select Retry on the notification message bar. Repeat for each query that shows a warning. After all queries have loaded, select Close & Apply.

    Important

    There is a two hour limit for Power BI report refresh. To prevent a timeout, we recommend keeping the data in your blob storage under these limits:

    • 50,000 blobs in total
    • 5GB of data in total

See also

Data sources for custom analytics