Failure to create local model with "DirectQuery for Power BI dataset and AS" enabled

[Liliya]

Hello,

I enabled "DirectQuery for Power BI dataset and AS" preview feature and connected to one of our datasets (“Get Data” -> “Power BI datasets”) on PBI service. Every attempt to create a local model using "Make changes to this model" feature fails with Internal Server (500) error. What could be the reason of this problem? The details are below.

Thank you

Feedback Type:
Frown (Error)

Timestamp:
2022-08-02T20:52:08.8127874Z

Local Time:
2022-08-02T15:52:08.8127874-05:00

Session ID:
a2368228-6ec3-4b41-891c-e9bbf62c53b8

Release:
July 2022

Product Version:
2.107.841.0 (22.07) (x64)

Stack Trace:
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException
at Microsoft.AnalysisServices.AdomdClient.ASAzureUtility.ThrowConnectionException(WebException ex, AsInstanceType asInstanceType)
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType()
at Microsoft.AnalysisServices.AdomdClient.CompressedStream.GetResponseDataType()
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CreateSession(ListDictionary properties, Boolean sendNamespaceCompatibility, String sessionToken)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.CreateSession(Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.AdomdQueryExecutor.OpenConnectionAndExecute[T](IAdomdConnectionPool connectionPool, IAdomdConnectionFactory connectionFactory, String connectionString, QueryExecutionOptions executionOptions, IPowerBITelemetryService telemetry, Func`2 execute)
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.ASLiveExternalService.ExecuteCommand[T](String name, Func`2 execute)
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.PowerBIService.PowerBIServiceLiveConnectionProperties.GetDatabasesAndCubes()
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.ProxyModelConnectionCompleter.CompleteConnectionPropertiesIfNecessary(ILiveConnectionProperties connectionProperties, IPowerBIWindowService windowService)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.LiveConnectToLocalDatabaseConverter.ShowNavigatorAndUpdateSelection(Report report, Query query, ILiveConnectionProperties liveConnectionProperties, IExceptionHandler exceptionHandler, IMinervaModalDialogManager minervaModalDialogManager, IPowerBIWindowService windowService, Func`1 applyChanges, ModelObject[] modelObjects)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.LiveConnectToLocalDatabaseConverter.<Convert>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.<TryConvertLiveConnectToProxyModel>d__57.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.107.841.0","ModuleName":"Microsoft.PowerBI.AdomdClient.dll","Component":"Microsoft.AnalysisServices.AdomdClient.ASAzureUtility","Error":"Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException","MethodDef":"ThrowConnectionException","ErrorOffset":"430"}

InnerException0.Stack Trace:
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.AnalysisServices.AdomdClient.HttpRequestResponseExtensions.GetResponseWithErrorHandling(HttpWebRequest httpWebRequest, Boolean isPbiPremium)
at Microsoft.AnalysisServices.AdomdClient.HttpStream.WaitForAndUpdateHttpResponseContainingXmlaPayload()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream()

OS Version:
Microsoft Windows NT 10.0.22000.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528449]

Peak Virtual Memory:
54.2 GB

Private Memory:
510 MB

Peak Working Set:
831 MB

IE Version:
11.1.22000.0

User ID:
a50bcf97-d411-417c-902c-a55340efb248

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_compositeModelsOverAS
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

[Anonymous]

Hi @Liliya ,

I was unable to reproduce your problem on the July version of Power BI Desktop.
1. Please check if your Dataset meets the conditions to use Directquery.
2. internal 500 error is usually a problem on the Server, have you used another dataset to see if you can connect properly?

500 Internal Server Errors: What They Are & How to Fix Them 

Considerations and limitations - Using DirectQuery for Power BI datasets and Analysis Services 

Best Regards,
Community Support Team _ Caitlyn

[Liliya]

Hi Caitlyn, thank you for the reply. The issue seems to be specific to my computer. I can add the same dataset to a local model from a terminal server and my collegue can do it from their PCs. On a side note (not sure if it is relevant), I also have an issue with refreshishing large datasets in import mode while it works on other computers (receive ODBC errors which are not even relevant). I understand that 500 is the server error but something related to my computer causes the issue. Anyway to troubleshoot? 

Thank you.