Failed to resolve the core XMLA server

[SreekanthChalla]

Hi,

I was trying to import another powerbi dataset shared by another user using Get data option. It is throwing an error message that 'Failed to resolve the core XMLA server'

Copied details to Clipboard

Feedback Type:
Frown (Error)

Timestamp:
2022-09-06T05:27:22.3010557Z

Local Time:
2022-09-06T10:57:22.3010557+05:30

Session ID:
62ff60e6-57cf-45b9-874f-1d26d1125c7a

Release:
September 2022

Product Version:
2.109.386.0 (22.09) (x64)

Stack Trace:
System.IO.InvalidDataException
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.109.386.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.UIBlockingService","Error":"System.IO.InvalidDataException","MethodDef":"AllowModalDialogs","ErrorOffset":"43"}

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

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

Peak Virtual Memory:
55.2 GB

Private Memory:
940 MB

Peak Working Set:
1.02 GB

IE Version:
11.1.22000.0

User ID:
919cd152-06f6-453e-a790-0d20ab430d07

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

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enableWebView2
PBI_sparklines

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

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
MSIT

DPI Scale:
300%

Supported Services:
Power BI >>

[Anonymous]

Hi @SreekanthChalla ,

Do you have build permission for this dataset?
If not, it is not possible to create reports etc. based on this dataset. Please make sure you have enough permissions for it.

Share access to a dataset - Power BI | Microsoft Docs

Also, what is your license? The error mentions XMLA, which requires you to be at least a PPU user in order to use it.
For more information on what XMLA is and some troubleshooting, please refer to these documents

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Docs

Best regards,

Community Support Team Selina zhu

[SreekanthChalla]

Hi Selina,

I do have access to the dataset, infact i could able to build views after succefully importing the dataset via 'Get Data ->PowerBi dataset' option, when the required dataset is imported individually.

The issue is seen, if you have combination of multiple datasets from various sources like Azure (ADO boards etc), excel etc and trying to import the powerbi dataset at that time i am seeing this peculiar issue. 

Thanks,
Sreekanth 

[Anonymous]

@SreekanthChalla ,

So do you aim to build composite models with multiple data sources?

You can't import multiple dataset from several datasource at same time, if you want to achieve, you need to use direct query connection mode after you have imported one dataset.

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

Best regards,

Community Support Team Selina zhu

[Anonymous]

We are experiencing a similar problem, only in Power BI services. In Power BI desktop refreshing is no problem, after publishing a manual refresh is also possible but the Power BI dataset gives an error: 

Situation: 
Composite model with 3 connections:

1 power BI dataset via DirectQuery (which gives the error stated below)

1 Azure SQL connection

1 Sharepoint page containing an Ex

Because of the remaining error we can't set a refresh schedule (greyed out). 

First time we got this error was september 9th. 

[Anonymous]

Hi @Anonymous ,

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best regards,

Community Support Team Selina zhu

[Anonymous]

Hi @Anonymous,

When following your instruction I'm being forced to use the 'new digital assistant', this is very very frustrating and a waste of my time. Is there a direct link to start a support ticket? 

[Anonymous]

Any news on this? I'm starting to get this error more and more which prevents me from setting refresh schedules and refreshing datasets. 

[Anonymous]

Any news? @Anonymous