web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Data refresh of marketing analytic reporting with Power BI is too long

(0) ShareShare
ReportReport
Posted on by 133

Hello,

First, wish you all the best for 2021.

We are currently working with the analytic Power BI reporting using Marketing application data: 

 https://docs.microsoft.com/en-us/dynamics365/marketing/custom-analytics

We found that the data refresh took too long time, about 6~8 hours if we need interactions data of 365 days back.

Has anyone encountered the same problem? Did you successfully optimize the refresh time?

Thank you in advance,

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    I would be really careful with using powerbi and the blob for Dynamics Marketing reporting. It has bitten us in the fingers. After a while (not very long) the system will have too many interaction records in the blob storage to do a refresh at all. After we've mentioned this to Microsoft it was added to their limitations... (https://docs.microsoft.com/en-us/dynamics365/marketing/marketing-analytics/analytics-gallery-start --> 50k blobs and 5gb storage)

    There is currently no plan on fixing this, because it is a preview feature. The suggestion was made to transfer everything to a datawarehouse so i guess that would be your solution. It is very unfortunate that dynamics 365 itself can't make use of the blob storage for simple d365 dashboarding. The only way to view analytics is by using the 'insights' tab on every record. Aggreragte dashboarding is not possible unless you use PowerBI, but that has severy limitations whichs means that you need to use a datawarehouse and powerbi to get simple aggregrate analytics. This was a severe issue for us. 

  • Suggested answer
    xhj45 Profile Picture
    133 on at

    Hi Niels vh,

    Thank you for your answer!

    For now we can only download the reporting then refresh the data using desktop version.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 151 Super User 2026 Season 1

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 51 Most Valuable Professional

#3
NeerajPawar Profile Picture

NeerajPawar 42

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans