Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm trying to add a reference layer to my Azure map. I'm getting a generic message - "An error occurred when rendering the report".
Some background:
The file is a geojson. It is an overlay of 3-digit zip codes that have been converted to polygons in ArcGIS. It was then exported from ArcGIS. Someone else exported it for me so I don't know the export settings/details. Below are the error details. Any ideas on the issue?
Feedback Type:
Frown (Error)
Error Message:
An error occurred while rendering the report.
Stack Trace:
Javascript:SyntaxError
at JSON.parse (<anonymous>)
at EmbeddedBrowserWebView.<anonymous> (<anonymous>:1:40576)
Stack Trace Message:
An error occurred while rendering the report.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
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.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
JS Error Message:
Unexpected end of JSON input
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.126.1261.0","ModuleName":"","Component":"EmbeddedBrowserWebView","Error":"SyntaxError","MethodDef":"<anonymous>","ErrorOffset":"1:40576","ErrorCode":""}
Snapshot Trace Logs:
C:\Users\100257020\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot3d1fce32-ab5c-43d1-917b-91044b5e565b.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\100257020\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_angularRls
PBI_backstageUI
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_generateMeasureDescriptionsButton
Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_EimLessElevatedUser
PBI_modelExplorer
PBI_daxQueryView
PBI_aiNarrativesVisual
PBI_qnaImproveLsdlCopilot
PBI_visualCalculationsAuthoring
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
PowerBIUserFeedbackServices_IsReported:
True
Formulas:
section Section1;
shared #"Admit Type" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimAdmitType = Source{[Schema="Final",Item="DimAdmitType"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimAdmitType,{{"Description", "Admit Type"}, {"UniqueDescription", "Admit Type Unique"}})
in
#"Renamed Columns";
shared #"Admit Source" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimAdmitSource = Source{[Schema="Final",Item="DimAdmitSource"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimAdmitSource,{{"Description", "Admit Source"}, {"UniqueDescription", "Admit Source Unique"}})
in
#"Renamed Columns";
shared #"Application Date" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimApplicationDate = Source{[Schema="Final",Item="DimApplicationDate"]}[Data]
in
Final_DimApplicationDate;
shared #"Application Decision" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimApplicationDecision = Source{[Schema="Final",Item="DimApplicationDecision"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimApplicationDecision,{{"Description", "Application Desc"}, {"UniqueDescription", "Applicated Desc Unique"}})
in
#"Renamed Columns";
shared #"Application Status" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimApplicationStatus = Source{[Schema="Final",Item="DimApplicationStatus"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimApplicationStatus,{{"Description", "Application Status"}, {"UniqueDescription", "Application Status Unique"}})
in
#"Renamed Columns";
shared #"Race/Ethnicity" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimEthnicity = Source{[Schema="Final",Item="DimEthnicity"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimEthnicity,{{"Description", "Race/Ethnicity"}, {"UniqueDescription", "Race/Ethnicity Unique"}})
in
#"Renamed Columns";
shared Gender = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimGender = Source{[Schema="Final",Item="DimGender"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimGender,{{"Description", "Gender"}, {"UniqueDescription", "Gender Unique"}})
in
#"Renamed Columns";
shared #"High School" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimHighSchool = Source{[Schema="Final",Item="DimHighSchool"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimHighSchool,{{"Description", "High School"}, {"UniqueDescription", "High School Unique"}}),
CustomColumn = Table.AddColumn(#"Renamed Columns", "MapURL", each
if [State] = "Unknown" or [State] = "Undefined" or [State] = "Canada" or [State] = "Federated States of Microne" or [State] = "Foreign State" or [State] = "Military - Americas" or [State] = "Military - Eur/Canada/MEast" or [State] = "Military - Pacific" or [State] = "Repulic of Palau" or [State] = "Foreign Country not Canada" then null else
let
// List of columns to concatenate
columnsToConcatenate = { [High School], [City], [State] },
// Remove null or blank values
nonBlankValues = List.RemoveNulls(columnsToConcatenate),
// Combine the non-blank values with a delimiter (e.g., comma)
concatenatedText = Text.Replace(Text.Combine(nonBlankValues, ",")," ","+"),
FullURL = "https://www.google.com/maps/search/?api=1&query=" & concatenatedText
in
FullURL
),
#"Removed Columns" = Table.RemoveColumns(CustomColumn,{"DeprecatedFinal.FactDegreeAward", "DeprecatedStage.FactDegreeAward", "Final.FactApplication", "Final.FactApplicationHistory", "Final.FactApplicationTransaction", "Final.FactDegreeTerm", "Stage.FactApplication", "Stage.FactApplicationHistory", "Stage.FactApplicationTransaction", "Stage.FactDegreeTerm"})
in
#"Removed Columns";
shared #"IPEDS Ethnicity" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimIPEDSEthnicity = Source{[Schema="Final",Item="DimIPEDSEthnicity"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimIPEDSEthnicity,{{"Description", "IPEDS Ethnicity"}, {"UniqueDescription", "IPEDS Ethnicity Unique"}})
in
#"Renamed Columns";
shared Student = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimStudent = Source{[Schema="Final",Item="DimStudent"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimStudent,{{"Description", "Student Full"}, {"UniqueDescription", "Student Full Unique"}})
in
#"Renamed Columns";
shared #"Zip Code" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimZipCode = Source{[Schema="Final",Item="DimZipCode"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimZipCode,{{"CountryDescription", "Country"}, {"CountyDescription", "County"}, {"CountyUniqueDescription", "County Unique"}, {"Description", "Zip Code"}, {"StateCode", "State Code"}, {"StateDescription", "State Unique"}, {"StateUniqueDescription", "State-Country Unique"}})
in
#"Renamed Columns";
shared FactApplication = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_FactApplication = Source{[Schema="Final",Item="FactApplication"]}[Data]
in
Final_FactApplication;
shared #"Key Measures" = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"})
in
#"Removed Columns";
shared Term = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimTerm = Source{[Schema="Final",Item="DimTerm"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimTerm,{{"AcademicYearCode", "Academic Year"}, {"AcademicYearAltName", "Acad Year Alt Name"}, {"Description", "Term"}, {"UniqueDescription", "Term Unique"}})
in
#"Renamed Columns";
shared Version = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimVersion = Source{[Schema="Final",Item="DimVersion"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimVersion,{{"Description", "Version"}})
in
#"Renamed Columns";
shared #"Enrolled Indicator" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimEnrolledIndicator = Source{[Schema="Final",Item="DimEnrolledIndicator"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimEnrolledIndicator,{{"Description", "Enrolled Indicator"}})
in
#"Renamed Columns";
shared #"Full-Time/Part-Time Indicator" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimFullTimePartTimeIndicator = Source{[Schema="Final",Item="DimFullTimePartTimeIndicator"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimFullTimePartTimeIndicator,{{"Description", "FTPT Indicator"}})
in
#"Renamed Columns";
shared FactApplicationHistory = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_FactApplicationHistory = Source{[Schema="Final",Item="FactApplicationHistory"]}[Data]
in
Final_FactApplicationHistory;
shared #"Prior Period" = let
//Creates a temporary table to hold the new OrderBy column
CustomList = {2,9,11,3,10,12,4,13,5,14,6,7,8,1,15},
ListTable = Table.FromList(CustomList, Splitter.SplitByNothing(), {"NewCol"}),
AddedIndex1 = Table.AddIndexColumn(ListTable, "Index", 1, 1, Int64.Type),
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimHistoryOffset = Source{[Schema="Final",Item="DimHistoryOffset"]}[Data],
RenamedColumns = Table.RenameColumns(Final_DimHistoryOffset,{{"Description", "Prior Period"}}),
RemovedColumns = Table.RemoveColumns(RenamedColumns,{"Final.FactApplicationHistory", "Stage.FactApplicationHistory"}),
#"Added Index" = Table.AddIndexColumn(RemovedColumns, "Index", 1, 1, Int64.Type),
#"Added Custom" = Table.AddColumn(#"Added Index", "OrderByIndex", each List.PositionOf(AddedIndex1[Index], [Index])),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "OrderBy2", each AddedIndex1[NewCol]{[OrderByIndex]}),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Index", "OrderByIndex"}),
#"Sorted Rows" = Table.Sort(#"Removed Columns",{{"OrderBy2", Order.Ascending}})
in
#"Sorted Rows";
shared #"Student Level" = let
Source = Sql.Database("w19-mssql1-p\bluecube", "iBNSA_41"),
Final_DimStudentLevel = Source{[Schema="Final",Item="DimStudentLevel"]}[Data],
#"Renamed Columns" = Table.RenameColumns(Final_DimStudentLevel,{{"Description", "Student Level"}, {"SourceKey", "Student Level Code"}, {"UniqueDescription", "Student Level-Unique"}, {"StudentLevelGroup", "Student Level Group"}})
in
#"Renamed Columns";
Active Section Contract:
{"name":"ReportSection83b571b175c9b098a024","displayName":"Azure Map Test","filters":"[{\"name\":\"Filter366b3d2fe7c046c90c55\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Term\"}},\"Property\":\"CurrentAdmissionsTerm\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"t\",\"Entity\":\"Term\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"t\"}},\"Property\":\"CurrentAdmissionsTerm\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"true\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}},{\"name\":\"Filter31b61b0fcbb4e000c54c\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Term\"}},\"Property\":\"Term\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"t\",\"Entity\":\"Term\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"t\"}},\"Property\":\"Term\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Fall 2024'\"}}],[{\"Literal\":{\"Value\":\"'Summer 2024'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]","ordinal":18,"visualContainers":[{"x":9.809290407044042,"y":0,"z":0,"width":1269.9761313653019,"height":720.0019158770326,"config":{"name":"f87e6613d066746242ac","layouts":[{"id":0,"position":{"x":9.809290407044042,"y":0,"z":0,"width":1269.9761313653019,"height":720.0019158770326,"tabOrder":0}}],"singleVisual":{"visualType":"azureMap","projections":{"Category":[{"queryRef":"High School.Zip3","active":true}],"Size":[{"queryRef":"Key Measures.Net Tuition Deposit Total"}]},"prototypeQuery":{"Version":2,"From":[{"Name":"h","Entity":"High School","Type":0},{"Name":"k","Entity":"Key Measures","Type":0}],"Select":[{"Column":{"Expression":{"SourceRef":{"Source":"h"}},"Property":"Zip3"},"Name":"High School.Zip3","NativeReferenceName":"Zip3"},{"Measure":{"Expression":{"SourceRef":{"Source":"k"}},"Property":"Net Tuition Deposit Total"},"Name":"Key Measures.Net Tuition Deposit Total","NativeReferenceName":"Net Tuition Deposit Total"}]},"drillFilterOtherVisuals":true,"objects":{"bubbleLayer":[{"properties":{"show":{"expr":{"Literal":{"Value":"true"}}}}}],"referenceLayer":[{"properties":{"additionalDatasource":{"geoJson":{"type":{"expr":{"Literal":{"Value":"'shared'"}}},"name":{"expr":{"Literal":{"Value":"'usa.states.topo'"}}},"content":{"expr":{"ResourcePackageItem":{"PackageName":"ShapeMap","PackageType":2,"ItemName":"usa.states.topo"}}}}}}}]}}},"filters":"[{\"name\":\"Filtera93d8810a9b008d5a70a\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"High School\"}},\"Property\":\"Zip3\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"h\",\"Entity\":\"High School\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"h\"}},\"Property\":\"Zip3\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Unknown'\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":0,\"objects\":{\"general\":[{\"properties\":{\"isInvertedSelectionMode\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}]},\"isHiddenInViewMode\":false}]"}],"config":{"visibility":1},"displayOption":1,"width":1280,"height":720}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.