Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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":"{}"}
Solved! Go to Solution.
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
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |