Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hello everybody.I am having a request that I do not know if it is possible at all.We are selling wood, and have some trucks driving around and delivering the wood to our customers. During the day we are getting orders in, and we directly type the orders in Navision 2016.We would like more overview over our orders, and therefore we came to talk about if it is possible to integrate Nav with Google Maps. At the office we have a big screen on the wall with Google Maps open. Is it possible to get all the open orders in NAV send to Google Maps, so we can see where we have to deliver our products? A practical example. A customer call us and place an order, and I register the order in NAV. When I look at Google Maps on our big screen on the wall, I can now see a new pin point with the order we have to deliver. Does anybody have experience og ideas how and if that could be solved?Best regardsMads
You could do it relatively easily with PowerBI.
Where are you based?
Please verify my answer if it helps you resolve this question, that way others can find this solution easier!
Thank you a lot for your reply Robert. We are based in Denmark. I was reading a little bit up on the Power Bi on this link: docs.microsoft.com/.../power-bi-visualization-filled-maps-choropleths.
I did not knew that the Power Bi could set the markers. Do you have a link for some more description on how to do it, or maybe a tutorial?
That's a good reference you've got, but I can't read danish. I've seen some videos of that guy though and they're good, it's a good start.
There are multiple ways you can do it, but what I would do is:
- get familiar with PowerBI by watching some of those videos here
- once you are familiar with that, try to create a report and enrich your data with Longitude and Latitude for the Ship to address details that you have on your orders.
* something like this one here if it's a good one (I haven't downloaded it), you'd need to import it in PowerBI and create a new table https://www.aggdata.com/free/denmark-postal-codes
- create a relation of 1-many from this table- post code to your Ship to Post code.
then create your visualization by using Longitude and Latitude.
*This is just an example, you may want to use a better source to map the exact address to Lon/Lat, if you can find a better data source online for Denmark addresses.
Thank you a lot, and sorry with the danish. There is a toggle to english in the menubar.
I will look into the links you gave me.
No worries, let us know how you go :)
McDuck4, also make sure the refresh data settings in Power BI is often enough for your needs, before going on this path.
Of course having only one screen to display it may be as easy as refreshing manually from PowerBI Desktop when you view it.
But see what options work for you between the free PowerBI Desktop, Pro version, Premium
If you need to access data on a remote server through SQL directly instead of webservices you can also use PowerBI Gateway:
Business Applications communities