Showing results for 
Search instead for 
Did you mean: 
mohitj83 New Member
New Member

Mandrill data incorrect when connected with PowerBI



I have connected my Mandrill service with my powerBI account. Various stats that PowerBI is showing are incorrect in PowerBI where as in Mandrill reports the stats are showing correctly, for eg:


1. The location data on the map does not show a few countries even though the click rates in these countries are the maximum.

2. It shows "Mail Opens" incorrectly. Shows the sends-opens as opens.



Is someone else also facing the same issue?


Can someone please help as this is really urgent?




Super User
Super User

Re: Mandrill data incorrect when connected with PowerBI

@mohitj83 - Your first issue sounds like a Bing maps geocoding issue. Power BI uses Bing maps to geocode data for display on map visualizations. You might be able to get answers to your question about certain countries in the Bing developer forums, etc.


Out of curiousity, what countries are affected and what is the data for that country. For example is it USA, United States or United States of America?


For your second question, this sounds like a content pack issue. I am not familiar with Mandrill's data set, however I have used and am familiar with other content packs. First, is the display that is wrong in the Dashboard, the underlying Report or both? You should be able to edit the underlying report and change the visualizes in terms of what is being displayed and then repin visualizations to dashboards. Of course, this is going to depend on what data model the Mandrill content pack provides you. For example, if it brings in opens, send-opens and then has some measure that combines the two and that is what it is displaying, then you could change it to just show opens (count of). However, if it only brings in the combined total, then you'll have to contact the author of the content pack or potentially submit a bug report here:

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 62 members 1,338 guests
Please welcome our newest community members: