Could not load file or assembly 'Microsoft.SqlServer.MgdSqlDumper.dll'

[jimmychan123]

Hello Everyone 

This issue is pending for longtime , any one can provide solutions for this ??

Feedback Type:
Frown (Error)

Error Message:
Could not load file or assembly 'Microsoft.SqlServer.MgdSqlDumper.dll' or one of its dependencies. The referenced assembly is not installed on your system. (Exception from HRESULT: 0x800736B3)

Stack Trace:
System.IO.FileLoadException
at Microsoft.PowerBI.ExploreHost.ExploreClient..ctor(IPowerViewHandler powerViewHandler, IFeatureSwitchesProxy featureSwitchesProxy, IDataShapeEngine dataShapeEngine, IQueryCancellationManager cancelManager)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>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)

Stack Trace Message:
Could not load file or assembly 'Microsoft.SqlServer.MgdSqlDumper.dll' or one of its dependencies. The referenced assembly is not installed on your system. (Exception from HRESULT: 0x800736B3)

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.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.130.930.0","ModuleName":"Microsoft.Powerbi.ExploreHost.dll","Component":"Microsoft.PowerBI.ExploreHost.ExploreClient","Error":"System.IO.FileLoadException","MethodDef":".ctor","ErrorOffset":"-1","ErrorCode":""}

PowerBIUserFeedbackServices_IsReported:
True

[rajendraongole1]

Hi @jimmychan123 - i think it is related to missing assembly of Microsoft.SqlServer.MgdSqlDumper.dll

try to uninstall the existing SQL Server component from control panel >> program and features

Package for your reference. install it.

Download Update for Microsoft Identity Manager 2016 SP1 (KB4050936) from Official Microsoft Download...

you can locate dll - Microsoft.SqlServer.MgdSqlDumper.dll file. It is usually located in the SQL Server installation directory, typically something like C:\Program Files\Microsoft SQL Server\130\Shared.

do a fresh install MS SQL Server using below link

Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn

Use a tool like Dependency Walker to check if there are any missing dependencies for the Microsoft.SqlServer.MgdSqlDumper.dll file. - Dependency Walker (depends.exe) Home Page

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!