Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Streaming Dataset Direct Query No Longer Working

I have had a streaming dataset that sits within a "staging"workspace that was working fine up until i have issues 2 weeks ago and had to rasie a microsoft ticket for refreshing issues

 

i can no longer import/direct query a live streaming dataset with the below error.

 

has worked fine for around 8 months up until 2 weeks ago and no access has changed and i am the curate of the streaming dataset so ihave full admin access

 

details below

 

 

Feedback Type:
Frown (Error)

Timestamp:
2023-01-27T15:43:47.1309379Z

Local Time:
2023-01-27T15:43:47.1309379+00:00

Session ID:
ea47f2d8-673d-426c-b079-f2c581a3bf2e

Release:
December 2022

Product Version:
2.112.1161.0 (22.12) (x64)

Stack Trace:
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.LiveConnectionPropertiesValidator.TryGetValidLiveConnectionProperties(IPowerBIWindowService windowService, ILiveConnectionProperties connectionProperties, Report report, ILiveConnectionCompleter liveConnectionPropertiesCompleter, ILiveConnectionProperties& validLiveConnectionProperties, Boolean& resultIsSameConnection, ValidationStatus& validationStatus)
at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.AreAnalysisServicesConnectionPropertiesValid(IPowerBIWindowService windowService, Report report, ILiveConnectionProperties connectionProperties, AnalysisServicesConnectionMode connectionMode, ILiveConnectionCompleter completer, ILiveConnectionProperties& validConnectionProperties)
at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ValidateAndCreateAnalysisServicesConnection(ILiveConnectionProperties connectionProperties, Boolean addToFormulaHistory, Boolean isExternalDataset)
at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.<>c__DisplayClass24_0.<<AddPowerBIDatahubSource>b__0>d.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.112.1161.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.UIBlockingService","Error":"Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException","MethodDef":"AllowModalDialogs","ErrorOffset":"43"}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-GB)

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

Peak Virtual Memory:
73 GB

Private Memory:
1.19 GB

Peak Working Set:
1.26 GB

IE Version:
11.789.19041.0

User ID:
81e0653c-0e27-4e63-8ccc-caf09076d7f9

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

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PBI_enableWebView2
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_b2bExternalDatasetSharing
PQ_WebView2Connector
PBI_NlToDax
PBI_optimizeTabRibbon
PBI_relationshipEditPane

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
225%

Supported Services:
Power BI

Status: Accepted

Hi @Screedy83 

It's a known issue . The engineers are working on your issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Accepted

Hi @Screedy83 

It's a known issue . The engineers are working on your issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao