Solved: Table Style Error - Unable to change table format ...

johnnystrada · ‎01-07-2022

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 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}

v-zhangti · ‎01-09-2022

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

Anonymous · ‎09-15-2022

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 · ‎01-09-2022