Getting a error "Specific method is not supported" while using direct query from databricks

[chaitubh]

Hi Power BI exprets,

Need your help!

I have a report its source is Azure Databricks sql end points with direct query. Im able to see all the tables are loading fine when i checked in query editor. but the visualizations are failing out and the error is "specif method is not supported".  

Im seeing the same error in service also.

below is the more detailed error:

Feedback Type:
Frown (Error)

Error Message:
Specified method is not supported.

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException

Server stack trace:

Exception rethrown at [0]:
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)

Exception rethrown at [1]:
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.get_PageReader()
at Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.Microsoft.OleDb.IEvaluationResultSource.WaitForResults()
at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IEvaluationResultSource.WaitForResults()

Stack Trace Message:
Specified method is not supported.

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.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<SendAndMarshalExceptions>b__0(Object null)
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__DisplayClass4_1.<Main>b__3()
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)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.109.642.0","ModuleName":"","Component":"Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Evaluator.Interface.ErrorException","MethodDef":"OnEvaluationComplete","ErrorOffset":""}

Snapshot Trace Logs:
C:\Users\Bhogireddy\Microsoft\Power BI Desktop Store App\FrownSnapShotfeaf31b9-1e5e-420a-b8ff-70046cba8a66.zip

Model Default Mode:
Composite

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBINonFatalError_ErrorDescription:
Microsoft.Mashup.Evaluator.Interface.ErrorException

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

shared Register = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_dimregister_Table = voyagerreporting_Schema{[Name="rpt_dimregister",Kind="Table"]}[Data]
in
rpt_dimregister_Table;

shared #"Register Summary" = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_factregistersummary_Table = voyagerreporting_Schema{[Name="rpt_factregistersummary",Kind="Table"]}[Data]
in
rpt_factregistersummary_Table;

shared #"Payment Allocation" = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_factpaymentallocation_Table = voyagerreporting_Schema{[Name="rpt_registerpaymentallocation",Kind="Table"]}[Data]
in
rpt_factpaymentallocation_Table;

shared Transaction = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_facttransaction_Table = voyagerreporting_Schema{[Name="rpt_facttransaction",Kind="Table"]}[Data]
in
rpt_facttransaction_Table;

shared #"Register Closing" = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_factregisterclosing_Table = voyagerreporting_Schema{[Name="rpt_factregisterclosing",Kind="Table"]}[Data]
in
rpt_factregisterclosing_Table;

shared #"Payment Method" = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_dimpaymentmethod_Table = voyagerreporting_Schema{[Name="rpt_dimpaymentmethod",Kind="Table"]}[Data]
in
rpt_dimpaymentmethod_Table;

shared #"Operational Unit" = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_dimoperationalunit_Table = voyagerreporting_Schema{[Name="rpt_dimoperationalunit",Kind="Table"]}[Data]
in
rpt_dimoperationalunit_Table;

shared Account = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_dimaccount_Table = voyagerreporting_Schema{[Name="rpt_dimaccount",Kind="Table"]}[Data]
in
rpt_dimaccount_Table;

shared Date = let
Source = Databricks.Catalogs("adb-863541109316906.6.azuredatabricks.net", "/sql/1.0/endpoints/08acfbf0524144c5", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
voyagerreporting_Schema = hive_metastore_Database{[Name="voyagerreporting",Kind="Schema"]}[Data],
rpt_dimdate_Table = voyagerreporting_Schema{[Name="rpt_dimdate",Kind="Table"]}[Data]
in
rpt_dimdate_Table;

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

*******************************************

Please help me out

Thanks,

Chaitanya

[chaitubh · Accepted solution]

Hello Everyone,

im able to solve the issue. 

I made date table as import mode, the visuals are loading fine now

[chaitubh]

The error is "OLE DB or ODBC error: Specific method is not supported"

im not using any meausres, im just using aggregations from fields directly and the visuals are table visual and card visuals.

[Greg_Deckler]

@chaitubh What is your measure formula? What visuals are you using? 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".