transformed data issue

khalilmr · ‎06-18-2023

getting below issue whenever i use trnasform data details of the issue was

Annotation 2023-06-18 115547.png

Feedback Type:
Frown (Error)

Error Message:
Retrieving the COM class factory for component with CLSID {926749FA-2615-4987-8845-C33E65F2B957} failed due to the following error: 8007007e The specified module could not be found. (Exception from HRESULT: 0x8007007E).

Stack Trace:
System.IO.FileNotFoundException
at Microsoft.Mashup.Client.UI.Windows.Ribbon.RibbonCoreBase.InitializeRibbon(IntPtr handle, CultureInfo currentUICulture)
at Microsoft.Mashup.Client.UI.Shared.Ribbon.EditorRibbonControlBase.InitializeControl()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Retrieving the COM class factory for component with CLSID {926749FA-2615-4987-8845-C33E65F2B957} failed due to the following error: 8007007e The specified module could not be found. (Exception from HRESULT: 0x8007007E).

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.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.Mashup.Host.Models.EventHandlerExtensions.RaiseEvent(EventHandler handler, Object sender)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Form.WmCreate(Message& m)
at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.WndProc(Message& m)
at Microsoft.Mashup.Client.UI.Windows.WebDialogWindow.WndProc(Message& message)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.IntCreateWindowEx(Int32 dwExStyle, String lpszClassName, String lpszWindowName, Int32 style, Int32 x, Int32 y, Int32 width, Int32 height, HandleRef hWndParent, HandleRef hMenu, HandleRef hInst, Object pvParam)
at System.Windows.Forms.UnsafeNativeMethods.IntCreateWindowEx(Int32 dwExStyle, String lpszClassName, String lpszWindowName, Int32 style, Int32 x, Int32 y, Int32 width, Int32 height, HandleRef hWndParent, HandleRef hMenu, HandleRef hInst, Object pvParam)
at System.Windows.Forms.UnsafeNativeMethods.CreateWindowEx(Int32 dwExStyle, String lpszClassName, String lpszWindowName, Int32 style, Int32 x, Int32 y, Int32 width, Int32 height, HandleRef hWndParent, HandleRef hMenu, HandleRef hInst, Object pvParam)
at System.Windows.Forms.NativeWindow.CreateHandle(CreateParams cp)
at System.Windows.Forms.Control.CreateHandle()
at System.Windows.Forms.Form.CreateHandle()
at System.Windows.Forms.Control.get_Handle()
at System.Windows.Forms.WebBrowserSiteBase.System.Windows.Forms.UnsafeNativeMethods.IOleInPlaceSite.GetWindowContext(IOleInPlaceFrame& ppFrame, IOleInPlaceUIWindow& ppDoc, COMRECT lprcPosRect, COMRECT lprcClipRect, tagOIFI lpFrameInfo)
at System.Windows.Forms.UnsafeNativeMethods.IOleObject.DoVerb(Int32 iVerb, IntPtr lpmsg, IOleClientSite pActiveSite, Int32 lindex, IntPtr hwndParent, COMRECT lprcPosRect)
at System.Windows.Forms.UnsafeNativeMethods.IOleObject.DoVerb(Int32 iVerb, IntPtr lpmsg, IOleClientSite pActiveSite, Int32 lindex, IntPtr hwndParent, COMRECT lprcPosRect)
at System.Windows.Forms.WebBrowserBase.DoVerb(Int32 verb)
at System.Windows.Forms.WebBrowserBase.TransitionFromRunningToInPlaceActive()
at System.Windows.Forms.WebBrowserBase.TransitionUpTo(AXState state)
at System.Windows.Forms.WebBrowser.get_AxIWebBrowser2()
at System.Windows.Forms.WebBrowser.get_Document()
at System.Windows.Forms.WebBrowser.get_ReadyState()
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.EnsureWebBrowserInitialized()
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.Show()
at Microsoft.PowerBI.Client.Windows.Services.QueriesEditorWindowManager.ShowQueryEditor(QueriesCommitPoint queriesCommitPoint, Query selectedQuery, Boolean isBlankQuery)
at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.<EditQueries>d__39.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.EditQueries(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, EditQueriesParameters parameters)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)
at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)
at Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<ExecuteCore>d__14.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.CommandStoreHostService.ExecuteCore(String commandId, String parameterJson, Int64 promiseHandle)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
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.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)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.118.621.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Windows.Ribbon.RibbonCoreBase","Error":"System.IO.FileNotFoundException","MethodDef":"InitializeRibbon","ErrorOffset":"0","ErrorCode":""}

Snapshot Trace Logs:
C:\Users\khalil.227\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShotd1ab12f7-801f-486c-a575-3f62aa35c245.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_enableWebView2
PQ_WebView2Connector
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_setLabelOnExportPdf
PBI_newCard

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

shared #"Actual-2022" = let
Source = Excel.Workbook(File.Contents("C:\Users\Mamdouh\OneDrive - Abdul Latif Jameel Company Ltd\Desktop\Region tasks\flash report\2nd amend\Actual - 2022.xlsx"), null, true),
#"Actual-2022_Sheet" = Source{[Item="Actual-2022",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Actual-2022_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Segment", Int64.Type}, {"Segment Name", type text}, {"Profit Center No.", Int64.Type}, {"Profit Center Name", type text}, {"Account No.", Int64.Type}, {"Account Name", type text}, {"Functional Area", Int64.Type}, {"FA", type text}, {"Activity", type text}, {"Actual", type number}})
in
#"Changed Type";

shared #"Actual-2023" = let
Source = Excel.Workbook(File.Contents("C:\Users\Mamdouh\OneDrive - Abdul Latif Jameel Company Ltd\Desktop\Region tasks\flash report\2nd amend\Actual - 2023.xlsx"), null, true),
#"Actual-2023_Sheet" = Source{[Item="Actual-2023",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Actual-2023_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Segment Number", Int64.Type}, {"Segment Name", type text}, {"Account Number", Int64.Type}, {"Account Name", type text}, {"Profitt Center Number", Int64.Type}, {"Profitt Center Name", type text}, {"Functional Area", Int64.Type}, {"FA", type text}, {"Activity", type text}, {"Actual", type number}})
in
#"Changed Type";

shared #"Budget-2023" = let
Source = Excel.Workbook(File.Contents("C:\Users\Mamdouh\OneDrive - Abdul Latif Jameel Company Ltd\Desktop\Region tasks\flash report\2nd amend\Budget - 2023.xlsx"), null, true),
#"Budget-2023_Sheet" = Source{[Item="Budget-2023",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Budget-2023_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Segment Number", Int64.Type}, {"Segment Name", type text}, {"Account Number", Int64.Type}, {"Account Name", type text}, {"Profitt Center Number", Int64.Type}, {"Profitt Center Name", type text}, {"Functional Area", Int64.Type}, {"FA", type text}, {"Activity", type text}, {"Plan", type number}})
in
#"Changed Type";

shared Mapping = let
Source = Excel.Workbook(File.Contents("C:\Users\Mamdouh\OneDrive - Abdul Latif Jameel Company Ltd\Desktop\Region tasks\flash report\2nd amend\Mapping.xlsx"), null, true),
Mapping_Sheet = Source{[Item="Mapping",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Mapping_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"AccountKey", Int64.Type}, {"Level 2", type text}, {"level 1", type text}})
in
#"Changed Type";

shared ProfitCenter = let
Source = Excel.Workbook(File.Contents("C:\Users\Mamdouh\OneDrive - Abdul Latif Jameel Company Ltd\Desktop\Region tasks\flash report\2nd amend\ProfitCenter.xlsx"), null, true),
ProfitCenter_Sheet = Source{[Item="ProfitCenter",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(ProfitCenter_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"PorfitCenterCode", Int64.Type}, {"ProfitCenter", type text}})
in
#"Changed Type";

shared Segment = let
Source = Excel.Workbook(File.Contents("C:\Users\Mamdouh\OneDrive - Abdul Latif Jameel Company Ltd\Desktop\Region tasks\flash report\2nd amend\Segment.xlsx"), null, true),
Segment_Table = Source{[Item="Segment",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Segment_Table,{{"Segment", Int64.Type}, {"Segment Text", type text}})
in
#"Changed Type";

shared structure = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8tMLTsxJLVaK1YlWcs4vLlHIT1NAiLjrKQQU5adlloB5/gWpRYklmXnpCq4VBal5xVBFCGGY2lgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"level 1" = _t]),
#"Renamed Columns" = Table.RenameColumns(Source,{{"level 1", "P&L Description"}}),
#"Added Index" = Table.AddIndexColumn(#"Renamed Columns", "Index", 1, 1, Int64.Type),
#"Added Conditional Column" = Table.AddColumn(#"Added Index", "Subtotal?", each if [Index] >= 5 then "1" else if [Index] >= 4 then 0 else if [Index] >= 3 then 1 else 0, type any),
#"Changed Type" = Table.TransformColumnTypes(#"Added Conditional Column",{{"Subtotal?", Int64.Type}})
in
#"Changed Type";

shared Mamdouh = 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";

v-yanjiang-msft · ‎06-18-2023

Hi @khalilmr ,

It sounds like an error “The specified module could not be found” occured. This could be caused by various reasons:

1. Malware attacks.

Hold down Windows + I key to open Settings > Select Update & Security > In the pop-up window, select Windows Defender in the left pane > Click Open Windows Defender Security Center > Virus & threat protection > Advanced Scan.

2. Missing or corrupted DLL file

Open File Explorer Option > In the pop-up window, go to the View tab and uncheck the option Hide protected operating system files (Recommended) > Click Apply > OK.

Boot your computer into Safe Mode and open Task Manager > In the Processes tab, select the program encountering the specified module could not be found error and choose End Task from the context menu to continue.
After that, reboot the program and check whether the problem is solved.

3. Damaged Windows Registry files.

Hold down Windows + R to open Run dialog > Type: regedit in the box and click OK to continue.
In the pop-up window, select the following keys and delete them.

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Run
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\RunOnce
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\RunOnce
Restart your PC to check the effect.

(Disclaimer: Generally, modifying registry subkeys or work group is intended for advanced users, administrators, and IT Professionals. It can help fix some problems, however, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For further protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click here to view the article.)

Reference: 4 Ways to Solve the Specified Module Could Not Be Found [db06-27c1-69d-ba2e] (minitool.com)

Best regards,

Communty Support Team_yanjiang

transformed data issue

June 2019 Update - Light Theme

New Card Visual inadvertently switching on values ...

fillter button condition formating colour

March 2025 update - Style preset error

SVG Image URL in Card (New) Visual is not working ...

Join us at FabCon Vienna from September 15-18, 2025

transformed data issue

June 2019 Update - Light Theme

New Card Visual inadvertently switching on values ...

fillter button condition formating colour

March 2025 update - Style preset error

SVG Image URL in Card (New) Visual is not working ...