cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Error with Sage ODBC

Hey, when trying to load Sage data into PowerBI using the ODBC we are getting this error:

 

Any ideas?

 

Feedback Type:
Frown (Error)
 
Error Message:
Value cannot be null.
Parameter name: exceptionType
 
Stack Trace:
   at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)
   at Microsoft.Mashup.Client.UI.Windows.JsHostedScript.TryInvoke[T](String script, T& result)
   at Microsoft.Mashup.Client.UI.Windows.JsHostedScript.TryInvoke(String script)
   at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.SetPreview(String preview)
   at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.OnGetPreview(PreviewResult preview)
   at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.<>c__DisplayClass17_0.<SetPreviewFromQuery>b__1(PreviewReference preview)
   at Microsoft.Mashup.Host.Document.Evaluation.PreviewEvaluationQueue.<>c__DisplayClass48_0.<OnPreviewComplete>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
 
Stack Trace Message:
Value cannot be null.
Parameter name: exceptionType
 
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 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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, IUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, IWebTableImporterHost webTableImporterHost)
   at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass76_1.<OnQuerySettingsResolved>b__0()
   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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
   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)
 

InnerException.Stack Trace Message:
Value cannot be null.
Parameter name: exceptionType
 
InnerException.Stack Trace:
Error: Value cannot be null.
Parameter name: exceptionType
   at QueryNavigatorPreviewViewHost.prototype._onRenderPreview (ms-pbi://pbi.microsoft.com/ts/Navigator/QueryNavigatorPreviewViewHost.js:178:17)
   at ResultViewHost.prototype._onRefreshSuccess (ms-pbi://pbi.microsoft.com/ts/Shared/ResultViews/ResultViewHost.js:265:13)
   at ResultViewHost.prototype.setPreviewContent (ms-pbi://pbi.microsoft.com/ts/Shared/ResultViews/ResultViewHost.js:53:13)
   at QueryNavigatorPreviewViewHost.prototype.setPreview (ms-pbi://pbi.microsoft.com/ts/Navigator/QueryNavigatorPreviewViewHost.js:81:17)
   at eval code (eval code:1:1)
 
InnerException.Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
   at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
   at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
   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 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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, IUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, IWebTableImporterHost webTableImporterHost)
   at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass76_1.<OnQuerySettingsResolved>b__0()
   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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
   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)
 

Model Default Mode:
Empty
 
Snapshot Trace Logs:
C:\Users\jono\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1036508711.zip
 
Performance Trace Logs:
C:\Users\jono\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
 
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_improvedFilterExperience
PBI_qnaLiveConnect
PBI_keyDrivers
 
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
 
Cloud:
GlobalCloud
 
Formulas:
 

section Section1;
 
shared AUDIT_HISTORY_SPLIT = let
    Source = Odbc.DataSource("userid=accounts;dsn=SEL 2", [HierarchicalNavigation=true]),
    AUDIT_HISTORY_SPLIT_Table = Source{[Name="AUDIT_HISTORY_SPLIT",Kind="Table"]}[Data]
in
    AUDIT_HISTORY_SPLIT_Table;
 
shared #"NavigatorBase_151a3e0d-a52b-4142-8370-24156e6bdc07" = let
    Source = Odbc.DataSource("dsn=SEL 2", [HierarchicalNavigation=true])
in
    Source;
4 REPLIES 4
mark_carlisle
Advocate III
Advocate III

I'm assuming by the error message you're using Sage 50 Accounts based in the UK?

If so when you connected to the data did you enter anything into the SQL statement box?
Anonymous
Not applicable

Hey,

 

Yes it is and haven't added anything at present

You'll need to enter a SQL statement for Power BI to connect, the Sage ODBC driver works fine with MS Query via Excel but with Power Query you need to be quite explicit; also in my experience attempting to retrieve [TABLE NAME].RECORD_CREATE_DATE[TABLE NAME].RECORD_MODIFY_DATE results in errors as well, so you'll probably want to avoid them.

 

I'm an ex-techie for Sage and used to do report design, I don't quite know what you are attempting to get from the AUDIT_HISTORY_SPLIT table, when I queried Demo data it was blank but that could just be the Demo data.

 

As an example for the AUDIT_HEADER table the SQL statement you'll want to use is;

 

SELECT AUDIT_HEADER.TRAN_NUMBER, AUDIT_HEADER.ITEM_COUNT, AUDIT_HEADER.TYPE, AUDIT_HEADER.DATE, AUDIT_HEADER.ACCOUNT_REF, AUDIT_HEADER.SALES_PURCHASE_REF, AUDIT_HEADER.BANK_CODE, AUDIT_HEADER.BANK_NAME, AUDIT_HEADER.INV_REF, AUDIT_HEADER.INV_REF_NUMERIC, AUDIT_HEADER.USER_NAME, AUDIT_HEADER.DETAILS, AUDIT_HEADER.DUE_DATE, AUDIT_HEADER.LAST_CHARGE_DATE, AUDIT_HEADER.FINANCE_CHARGE, AUDIT_HEADER.INTEREST_RATE, AUDIT_HEADER.ELECTRONIC_TRANS, AUDIT_HEADER.DISPUTED, AUDIT_HEADER.PAID_FLAG, AUDIT_HEADER.PAID_STATUS, AUDIT_HEADER.DELETED_FLAG, AUDIT_HEADER.DATE_FLAG, AUDIT_HEADER.DATE_BF, AUDIT_HEADER.DATE_FROM, AUDIT_HEADER.DATE_TO, AUDIT_HEADER.NET_AMOUNT, AUDIT_HEADER.TAX_AMOUNT, AUDIT_HEADER.GROSS_AMOUNT, AUDIT_HEADER.BANK_AMOUNT, AUDIT_HEADER.AMOUNT_PAID, AUDIT_HEADER.PAYMENT, AUDIT_HEADER.OUTSTANDING, AUDIT_HEADER.FOREIGN_OUTSTANDING, AUDIT_HEADER.FOREIGN_NET_AMOUNT, AUDIT_HEADER.FOREIGN_TAX_AMOUNT, AUDIT_HEADER.FOREIGN_GROSS_AMOUNT, AUDIT_HEADER.FOREIGN_AMOUNT_PAID, AUDIT_HEADER.FOREIGN_BANK_AMOUNT, AUDIT_HEADER.CURRENCY, AUDIT_HEADER.CURRENCY_TYPE, AUDIT_HEADER.EURO_GROSS, AUDIT_HEADER.EURO_RATE, AUDIT_HEADER.FOREIGN_RATE, AUDIT_HEADER.IS_DISCOUNT, AUDIT_HEADER.AGED_BALANCE, AUDIT_HEADER.AGED_FUTURE, AUDIT_HEADER.AGED_CURRENT, AUDIT_HEADER.AGED_30, AUDIT_HEADER.AGED_60, AUDIT_HEADER.AGED_90, AUDIT_HEADER.AGED_OLDER, AUDIT_HEADER.AGED_CUM_CURRENT, AUDIT_HEADER.AGED_CUM_30, AUDIT_HEADER.AGED_CUM_60, AUDIT_HEADER.AGED_CUM_90, AUDIT_HEADER.FOREIGN_AGED_BALANCE, AUDIT_HEADER.FOREIGN_AGED_FUTURE, AUDIT_HEADER.FOREIGN_AGED_CURRENT, AUDIT_HEADER.FOREIGN_AGED_30, AUDIT_HEADER.FOREIGN_AGED_60, AUDIT_HEADER.FOREIGN_AGED_90, AUDIT_HEADER.FOREIGN_AGED_OLDER, AUDIT_HEADER.FOREIGN_AGED_CUM_CURRENT, AUDIT_HEADER.FOREIGN_AGED_CUM_30, AUDIT_HEADER.FOREIGN_AGED_CUM_60, AUDIT_HEADER.FOREIGN_AGED_CUM_90, AUDIT_HEADER.BANK_FLAG, AUDIT_HEADER.HEADER_NUMBER, AUDIT_HEADER.DATE_ENTERED, AUDIT_HEADER.DATE_BANK_RECONCILED, AUDIT_HEADER.CIS_RECONCILED, AUDIT_HEADER.SPS_REF, AUDIT_HEADER.DEPOSIT_DATE, AUDIT_HEADER.DEPOSIT_FLAG, AUDIT_HEADER.RECURRING_ENTRY_ID, AUDIT_HEADER.ISP_REFERENCE, AUDIT_HEADER.OVERRIDDEN_CLOSED_LEDGER_DATE, AUDIT_HEADER.COUNTRY_CODE, AUDIT_HEADER.TAX_ID, AUDIT_HEADER.REVAL_TRANSACTION_FLAG, AUDIT_HEADER.POSTED_BY_DIRECT_DEBIT_SETTLEMENT, AUDIT_HEADER.DATE_AMENDED, AUDIT_HEADER.USER_NAME_AMENDED, AUDIT_HEADER.BANK_CHARGE_ACCOUNT, AUDIT_HEADER.BANK_CHARGE_IS_CUSTOMER, AUDIT_HEADER.IS_INVOICE_PAYMENT, AUDIT_HEADER.BANK_RECONCILIATION_REF, AUDIT_HEADER.BANK_RECONCILIATION_ID, AUDIT_HEADER.RECORD_DELETED
FROM AUDIT_HEADER AUDIT_HEADER
ORDER BY AUDIT_HEADER.TRAN_NUMBER

The best place to find the column names for each table would probably be the Sage Report Designer software. Open a report that does something similar to what you want to achieve in Power BI, then click Report and then Joins. The Join Editor will open and you can then see all the tables that make up that report, and column names within those tables. All you would need to do is write your SQL statement to bring in the columns you want. You may also want to use the same joins in Power BI as well if you're trying to recreate the same report.

Your Solution worked for me . Thanks a lot!!!!!!!!!!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors