cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnnystrada
Regular Visitor

Table Style Error - Unable to change table format style

I am unable to change the style whenever a new table is created. I am prompted with the "Something went wrong" notification every time. Details from the latest error are below. I have uninstalled and reinstalled but nothing has improved the functionality.  Any help would be greatly appreciated as this is severely limiting my customizability. 

 

Feedback Type:
Frown (Error)

Error Message:
An error occurred while rendering the report.

Stack Trace:
Javascript: TypeError
at clearStylePresetDefinedProperties (https://ms-pbi.pbi.microsoft.com/minerva/scripts/exploreUIShell.js:6069:87)
at Object.saveVisualProperty [as save] (https://ms-pbi.pbi.microsoft.com/minerva/scripts/exploreUIShell.js:6060:94)
at https://ms-pbi.pbi.microsoft.com/minerva/scripts/exploreUIShell.js:7264:51
at UndoRedoStack.register (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:18694:163)
at UndoRedoService.register (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:18654:52)
at UndoRedoService.register (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:234610:47)
at _loop_3 (https://ms-pbi.pbi.microsoft.com/minerva/scripts/exploreUIShell.js:7263:267)
at PropertyPaneController.save (https://ms-pbi.pbi.microsoft.com/minerva/scripts/exploreUIShell.js:7278:25)
at fn (eval at compile (https://ms-pbi.pbi.microsoft.com/minerva/scripts/angular.js:16508:15), <anonymous>:4:311)
at PropertyCardController.destination.<computed> [as cardChanged] (https://ms-pbi.pbi.microsoft.com/minerva/scripts/angular.js:11497:22)

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__DisplayClass15_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.UIBlockingAwareExceptionHandler.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__DisplayClass4_1.<Main>b__2()
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.Main(String[] args)


JS Error Message:
Cannot read properties of undefined (reading 'stylePreset')

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.100.785.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/exploreUIShell.js","Component":"","Error":"TypeError","MethodDef":"clearStylePresetDefinedProperties","ErrorOffset":"6069:87"}

Snapshot Trace Logs:
C:\Users\17944.CITY\Microsoft\Power BI Desktop Store App\FrownSnapShot7cfe42d4-5ee8-4d01-8d19-262f4daf5cd0.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\17944.CITY\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_enableWebView2
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_useModernFormatPane
PBI_scorecardVisual

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
USGovCloud

Recent Actions:
VisualContainerUpdateDimensions, SavePropertyPane, SavePropertyPane, SavePropertyPane, SavePropertyPane, SavePropertyPane, SavePropertyPane, VisualContainerUpdateDimensions, VisualContainerUpdateDimensions, VisualContainerUpdateDimensions, VisualContainerUpdateDimensions, VisualContainerPersistProperties, VisualContainerPersistProperties, VisualContainerPersistProperties, VisualContainerUpdateDimensions

PowerBIUserFeedbackServices_IsReported:
True

Formulas:


section Section1;

shared MondayBoard = let
Source = Excel.Workbook(Web.Contents("https://cityofmobile.sharepoint.com/sites/iTeam/Shared%20Documents/OneDrive/%7bStrategic%20Plan%7d/1..."), null, true),
MondayBoard_Sheet = Source{[Item="MondayBoard",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(MondayBoard_Sheet, [PromoteAllScalars=true])
in
#"Promoted Headers";

Active Section Contract:
{"name":"ReportSection00aebfc1c45791eed607","displayName":"Tracker","filters":"[]","ordinal":0,"visualContainers":[{"x":0,"y":0,"z":0,"width":1279.6893203883494,"height":144.4660194174757,"config":{"name":"921f85086e16227a96cb","layouts":[{"id":0,"position":{"x":0,"y":0,"z":0,"width":1279.6893203883494,"height":144.4660194174757,"tabOrder":0}}],"singleVisual":{"visualType":"textbox","drillFilterOtherVisuals":true,"objects":{"general":[{"properties":{"paragraphs":[{"textRuns":[{"value":"City Action Tracker","textStyle":{"fontWeight":"bold","fontSize":"60pt","color":"#99e3dd"}}],"horizontalTextAlignment":"center"}]}}]},"vcObjects":{"dropShadow":[{"properties":{"show":{"expr":{"Literal":{"Value":"false"}}},"color":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":0,"Percent":0}}}}},"position":{"expr":{"Literal":{"Value":"'Outer'"}}},"preset":{"expr":{"Literal":{"Value":"'BottomLeft'"}}},"angle":{"expr":{"Literal":{"Value":"135L"}}},"shadowDistance":{"expr":{"Literal":{"Value":"10L"}}},"shadowBlur":{"expr":{"Literal":{"Value":"10L"}}},"shadowSpread":{"expr":{"Literal":{"Value":"3L"}}},"transparency":{"expr":{"Literal":{"Value":"70L"}}}}}]}}},"filters":"[]"},{"x":1054.020618556701,"y":632.4123711340205,"z":1000,"width":225.64948453608247,"height":89.0721649484536,"config":{"name":"be01e8e7f38c036eeb40","layouts":[{"id":0,"position":{"x":1054.020618556701,"y":632.4123711340205,"z":1000,"width":225.64948453608247,"height":89.0721649484536,"tabOrder":1000}}],"singleVisual":{"visualType":"textbox","drillFilterOtherVisuals":true,"objects":{"general":[{"properties":{"paragraphs":[{"textRuns":[{"value":"Latest update:","textStyle":{"fontFamily":"Arial","fontSize":"10pt","color":"#ffffff"}}],"horizontalTextAlignment":"center"}]}}]}}},"filters":"[]","tabOrder":1000},{"x":1054.020618556701,"y":660.1237113402061,"z":2000,"width":225.64948453608247,"height":60.371134020618555,"config":{"name":"f97a89ee681b68e9dcaf","layouts":[{"id":0,"position":{"x":1054.020618556701,"y":660.1237113402061,"z":2000,"width":225.64948453608247,"height":60.371134020618555,"tabOrder":2000}}],"singleVisual":{"visualType":"card","projections":{"Values":[{"queryRef":"Min(MondayBoard.CURENTTIME)"}]},"prototypeQuery":{"Version":2,"From":[{"Name":"m","Entity":"MondayBoard","Type":0}],"Select":[{"Aggregation":{"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"m"}},"Property":"CURENTTIME"}},"Function":3},"Name":"Min(MondayBoard.CURENTTIME)"}]},"columnProperties":{"Min(MondayBoard.CURENTTIME)":{"displayName":"Update time"}},"drillFilterOtherVisuals":true,"objects":{"labels":[{"properties":{"color":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":0,"Percent":0}}}}},"fontSize":{"expr":{"Literal":{"Value":"14D"}}}}}],"categoryLabels":[{"properties":{"show":{"expr":{"Literal":{"Value":"false"}}}}}]}}},"filters":"[]","tabOrder":2000},{"x":7.917525773195876,"y":632.4123711340205,"z":3000,"width":287.0103092783505,"height":88.08247422680412,"config":{"name":"adb6c8b8a492b4acf63a","layouts":[{"id":0,"position":{"x":7.917525773195876,"y":632.4123711340205,"z":3000,"width":287.0103092783505,"height":88.08247422680412,"tabOrder":3000}}],"singleVisual":{"visualType":"image","drillFilterOtherVisuals":true,"objects":{"general":[{"properties":{"imageUrl":{"expr":{"ResourcePackageItem":{"PackageName":"RegisteredResources","PackageType":1,"ItemName":"Logo_Innovation_Transparent7106821258950555.png"}}}}}]}}},"filters":"[]","tabOrder":3000},{"x":7.917525773195876,"y":632.4123711340205,"z":4000,"width":287.0103092783505,"height":37.60824742268041,"config":{"name":"1f27b3ff3b4270f3ecc4","layouts":[{"id":0,"position":{"x":7.917525773195876,"y":632.4123711340205,"z":4000,"width":287.0103092783505,"height":37.60824742268041,"tabOrder":4000}}],"singleVisual":{"visualType":"textbox","drillFilterOtherVisuals":true,"objects":{"general":[{"properties":{"paragraphs":[{"textRuns":[{"value":"iTeam Mobile","textStyle":{"fontWeight":"bold","fontFamily":"Corbel","fontSize":"12pt","color":"#ffffff"},"url":"https://www.iteammobile.org"}],"horizontalTextAlignment":"center"}]}}]}}},"filters":"[]","tabOrder":4000},{"x":274.1443298969072,"y":144.49484536082474,"z":4001,"width":855.0927835051546,"height":576,"config":{"name":"00088fb33b6c20fa0428","layouts":[{"id":0,"position":{"x":274.1443298969072,"y":144.49484536082474,"z":4001,"width":855.0927835051546,"height":576,"tabOrder":4001}}],"singleVisual":{"visualType":"tableEx","projections":{"Values":[{"queryRef":"MondayBoard.Department"},{"queryRef":"MondayBoard.TotalProjects"},{"queryRef":"MondayBoard.% complete"}]},"prototypeQuery":{"Version":2,"From":[{"Name":"m","Entity":"MondayBoard","Type":0}],"Select":[{"Arithmetic":{"Left":{"Measure":{"Expression":{"SourceRef":{"Source":"m"}},"Property":"TotalProjects"}},"Right":{"ScopedEval":{"Expression":{"Measure":{"Expression":{"SourceRef":{"Source":"m"}},"Property":"TotalProjects"}},"Scope":[]}},"Operator":3},"Name":"MondayBoard.TotalProjects"},{"Column":{"Expression":{"SourceRef":{"Source":"m"}},"Property":"Department"},"Name":"MondayBoard.Department"},{"Measure":{"Expression":{"SourceRef":{"Source":"m"}},"Property":"% complete"},"Name":"MondayBoard.% complete"}],"OrderBy":[{"Direction":1,"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"m"}},"Property":"Department"}}}]},"columnProperties":{"MondayBoard.TotalProjects":{"displayName":"% Assigned"},"MondayBoard.% complete":{"displayName":"% Complete"}},"drillFilterOtherVisuals":true,"objects":{"columnFormatting":[{"properties":{"backColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"fontColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":0,"Percent":0}}}}},"labelPrecision":{"expr":{"Literal":{"Value":"1L"}}},"alignment":{"expr":{"Literal":{"Value":"'Center'"}}},"dataBars":{"positiveColor":{"solid":{"color":{"expr":{"Literal":{"Value":"'#999999'"}}}}},"negativeColor":{"solid":{"color":{"expr":{"Literal":{"Value":"'minColor'"}}}}},"axisColor":{"solid":{"color":{"expr":{"Literal":{"Value":"'#999999'"}}}}},"reverseDirection":{"expr":{"Literal":{"Value":"false"}}},"hideText":{"expr":{"Literal":{"Value":"true"}}}}},"selector":{"metadata":"MondayBoard.TotalProjects"}},{"properties":{"backColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0.2}}}}},"fontColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":0,"Percent":0}}}}},"alignment":{"expr":{"Literal":{"Value":"'Center'"}}}},"selector":{"metadata":"MondayBoard.Department"}},{"properties":{"backColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"fontColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":0,"Percent":0}}}}},"labelPrecision":{"expr":{"Literal":{"Value":"0L"}}},"alignment":{"expr":{"Literal":{"Value":"'Center'"}}},"dataBars":{"positiveColor":{"solid":{"color":{"expr":{"Literal":{"Value":"'#73F200'"}}}}},"negativeColor":{"solid":{"color":{"expr":{"Literal":{"Value":"'minColor'"}}}}},"axisColor":{"solid":{"color":{"expr":{"Literal":{"Value":"'#73F200'"}}}}},"reverseDirection":{"expr":{"Literal":{"Value":"false"}}},"hideText":{"expr":{"Literal":{"Value":"true"}}}}},"selector":{"metadata":"MondayBoard.% complete"}}],"grid":[{"properties":{"gridHorizontal":{"expr":{"Literal":{"Value":"false"}}},"gridHorizontalColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"gridVertical":{"expr":{"Literal":{"Value":"false"}}},"gridVerticalColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"gridHorizontalWeight":{"expr":{"Literal":{"Value":"3D"}}},"rowPadding":{"expr":{"Literal":{"Value":"8D"}}},"outlineWeight":{"expr":{"Literal":{"Value":"3D"}}}}}],"columnHeaders":[{"properties":{"backColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"fontColor":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":0,"Percent":0}}}}},"fontFamily":{"expr":{"Literal":{"Value":"'''Trebuchet MS'''"}}},"alignment":{"expr":{"Literal":{"Value":"'Center'"}}},"bold":{"expr":{"Literal":{"Value":"true"}}},"fontSize":{"expr":{"Literal":{"Value":"10D"}}}}}],"total":[{"properties":{"totals":{"expr":{"Literal":{"Value":"false"}}}}}],"values":[{"properties":{"fontFamily":{"expr":{"Literal":{"Value":"'''Trebuchet MS'''"}}},"fontSize":{"expr":{"Literal":{"Value":"15D"}}}}}],"columnWidth":[{"properties":{"value":{"expr":{"Literal":{"Value":"242.15311219490098D"}}}},"selector":{"metadata":"MondayBoard.TotalProjects"}},{"properties":{"value":{"expr":{"Literal":{"Value":"332.87302726835213D"}}}},"selector":{"metadata":"MondayBoard.Department"}},{"properties":{"value":{"expr":{"Literal":{"Value":"261.1095883595636D"}}}},"selector":{"metadata":"MondayBoard.% complete"}}]}}},"filters":"[{\"name\":\"Filter4af3c5ef725e98c541e6\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"MondayBoard\"}},\"Property\":\"Primary\"}},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{\"general\":[{\"properties\":{\"isInvertedSelectionMode\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}]},\"isHiddenInViewMode\":false},{\"expression\":{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"MondayBoard\"}},\"Property\":\"TotalProjects\"}},\"type\":\"Advanced\",\"howCreated\":1,\"isHiddenInViewMode\":false},{\"name\":\"Filterd273cb158aaf75b6abb5\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"MondayBoard\"}},\"Property\":\"Department\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"m\",\"Entity\":\"MondayBoard\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"m\"}},\"Property\":\"Department\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":0,\"objects\":{\"general\":[{\"properties\":{\"isInvertedSelectionMode\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}]},\"isHiddenInViewMode\":false}]","tabOrder":4001}],"config":{"objects":{"background":[{"properties":{"color":{"solid":{"color":{"expr":{"ThemeDataColor":{"ColorId":1,"Percent":0}}}}},"transparency":{"expr":{"Literal":{"Value":"0D"}}},"image":{"image":{"name":{"expr":{"Literal":{"Value":"'citylogo.png'"}}},"url":{"expr":{"ResourcePackageItem":{"PackageName":"RegisteredResources","PackageType":1,"ItemName":"citylogo020137474331911154.png"}}},"scaling":{"expr":{"Literal":{"Value":"'Normal'"}}}}}}}]}},"displayOption":1,"width":1280,"height":720}

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @johnnystrada 

 

A fix has been deployed to address this issue. Could you follow steps below from this thread to see if it works now?

 

1) Close all instances of Power BI Desktop

2) Open file explorer and navigate to the folder <system drive>:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop\CEF\cache

  • replace <system drive> with your operating system hard disk partition
  • replace <user> with your user profile name, typically the alias you login to Windows with

3) Delete all contents of this folder

4) Restart Power BI Desktop

 

Best Regards,

Community Support Team _Charlotte

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

2 REPLIES 2
DataDownUnder
Frequent Visitor

I have the same issue and the above fix has not resolved it with a persistant "An error ocurred while rendering the report" when I try to change the s tyle of a table.  Is there an updated fix for this?

v-zhangti
Community Support
Community Support

Hi, @johnnystrada 

 

A fix has been deployed to address this issue. Could you follow steps below from this thread to see if it works now?

 

1) Close all instances of Power BI Desktop

2) Open file explorer and navigate to the folder <system drive>:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop\CEF\cache

  • replace <system drive> with your operating system hard disk partition
  • replace <user> with your user profile name, typically the alias you login to Windows with

3) Delete all contents of this folder

4) Restart Power BI Desktop

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.