Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JeffPBI1234
New Member

Error when trying to create map

I cannot get the map feature to work.  I have a very small set of data with City name, zip, lat/long, and some metrics data.  Every time I put the Zip field into the Location or if I put Lat or Long into their respective fields, I get "Unexpected Error; An error occured while rendering the report".  Here are the details from the error:

 

Feedback Type:
Frown (Error)

Timestamp:
2018-04-10T15:33:12.3525731Z

Local Time:
2018-04-10T10:33:12.3525731-05:00

Product Version:
2.43.4647.541 (PBIDesktop) (x64)

Release:
February 2017

IE Version:
11.909.15063.0

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-US)

CLR Version:
4.6.2. or later [Release Number = 460798]

Workbook Package Info:
1* - en-US, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
385 MB

Private Memory:
290 MB

Peak Virtual Memory:
34.6 GB

JS Error Message:
Cannot read property 'roadUriFormat' of undefined

Error Message:
An error occurred while rendering the report.

Stack Trace:
Microsoft.Mashup.Host.Document.JavaScriptException: An error occurred while rendering the report.
TypeError: Cannot read property 'roadUriFormat' of undefined
at Function.Map.removeHillShading (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:39754:82)
at ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:39074:51
at processQueue (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16383:28)
at ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16399:27
at Scope.$eval (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:17682:28)
at Scope.$digest (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:17495:31)
at ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:17721:26
at completeOutstandingRequest (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:5964:10)
at ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:6243:7

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
3afd13ef-3af4-4216-b584-20389274aed7

Session ID:
d85f576d-e655-4310-9694-ff9a16d534f5

Telemetry Enabled:
False

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\jkeenej\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot150921922.zip

Performance Trace Logs:
C:\Users\jkeenej\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_RedShift
PBI_Impala
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_allowBiDiCrossFilterInDirectQuery
PBI_clusteringEnabled
PBI_esriEnabled

Disabled DirectQuery Options:
DirectQuery_Unrestricted

Cloud:
GlobalCloud

Recent Actions:
AddEmptyVisualContainer, AddFieldInRole

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared Sheet1 = let
Source = Excel.Workbook(File.Contents("C:\Users\jkeenej\Desktop\inv vs orders tableau.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"plant city", type text}, {"zip", Int64.Type}, {"avg order", type number}, {"avg inv", type number}, {"latitude", type number}, {"longitude", type number}})
in
#"Changed Type";

Active Section Contract:
{"id":0,"name":"ReportSection","displayName":"Page 1","ordinal":0,"visualContainers":[{"x":10,"y":20,"z":1,"width":280,"height":280,"config":"{\"layouts\":[{\"id\":0,\"position\":{\"x\":10,\"y\":20,\"width\":280,\"height\":280,\"z\":1}}],\"singleVisual\":{\"visualType\":\"map\",\"projections\":{\"Category\":[{\"queryRef\":\"Sheet1.zip\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"zip\"},\"Name\":\"Sheet1.zip\"}]}},\"name\":\"VisualContainer\"}"}],"displayOption":1,"width":1280,"height":720,"config":"{}"}

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

Hi @JeffPBI1234,

 

What map visual did you use?

 

Based on my research, it looks like there was a bug with the ArcGIS visual in Power BI desktop Feb 2017 release. Please update your desktop version to the latest one. Also, you can follow these steps to fix this problem.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yulgu-msft
Employee
Employee

Hi @JeffPBI1234,

 

What map visual did you use?

 

Based on my research, it looks like there was a bug with the ArcGIS visual in Power BI desktop Feb 2017 release. Please update your desktop version to the latest one. Also, you can follow these steps to fix this problem.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.