27
I am working with the Dynamics 365 Marketing Power BI templates. I have noticed that in the D365 interface there is an insight metric for Visit Duration available, but I do not see that interaction available in the "Known Interactions" query in the PBI template. Is there a way to get this data to use in the reports?
Thank you.
Hi Defne,
I have done all of the things you mentioned. The issue is that even in the long list of interactions that I can see and report and have data for, I do not see visit duration in that list. It is not listed in the https://docs.microsoft.com/en-us/dynamics365/marketing/insights-glossary either. I am able to work out how to load interactions that are not active within certain templates, but visit duration is not included in the list of known interactions. I'm trying to figure out if this is a configuration issue in our D365, or something missed in the templates, or just something I am missing or need to enable.
Thank you.
Hi tcmanders,
Yes, you can use any interaction data including "visit duration" in your reports.
You just need to set up the Power BI "Azure Blob Storage" connector for Interaction type of data.
Interaction data is stored in the marketing-insights service database and includes information about how your contacts interacted with your marketing initiatives, including email opens, email clicks, event registrations, page submissions, and more. You can see this type of information when you look at the insights built into Dynamics 365 Marketing, but you can't create these records nor view them directly. In the current release, you'll use the Power BI "Azure Blob Storage" connector for this type of data. In future releases you'll also be able use the dataflow connector.
You'll be able to connect directly to your Dynamics 365 Marketing database from Power BI to fetch your profile data, but to access interaction data you'll need to set up Azure Blob Storage, configure Dynamics 365 Marketing to save interaction data there, and then connect Power BI to your blob storage.
Best Regards,
Defne
Microsoft Dynamics 365 for Marketing team
Don't forget!: If you have gotten the answer to your question - mark your question as answered (even if the answer is not what you have hoped for). By doing so you show appreciation to the free-of-charge help that you have received from another forum member.
Hi tcmanders,
From your screenshot, it seems it's a marketing page record.
If you would like to analyse insights data in power bi,
please firstly test a contact, do some interaction such as form submission behavior to generate insights data, once some data have been generated,
then connect power bi to marketing application with following guidances:
https://docs.microsoft.com/en-us/dynamics365/marketing/custom-analytics
https://docs.microsoft.com/en-us/dynamics365/marketing/marketing-analytics/analytics-gallery-start
Regards,
Clofly
#1
André Arnaud de Cal...
292,865
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
