Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have recently had an issue with an OData.Feed to https://api.securitycenter.microsoft.com/api/machines which was working fine until earlier this week. Other than general patches to my machine there haven't been any changes I am aware of. I have also tried it on more than one machine and in a new power BI document to make sure there aren't any code issues. I also have other OData feeds to Microsoft and other websites that are working without any issues.
The code is very simple and is produced by power BI when selecting OData as the feed type, it hadn't been altered by me:
Source = OData.Feed("https://api.securitycenter.microsoft.com/api/machines", null, [Implementation="2.0"])
The error received is:
Error
The value 'System.String[]' of the OData-Version HTTP header is invalid. Only '4.0' is supported as values for the OData-Version header.
True
Details from the error are:
Feedback Type:
Frown (Error)
Release:
October 2022
Product Version:
2.110.805.0 (22.10) (x64)
Stack Trace:
Microsoft.Mashup.Client.UI.Shared.ExceptionResultException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.110.805.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Client.UI.Shared.ExceptionResultException","MethodDef":"OnException","ErrorOffset":""}
OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-GB)
CLR Version:
4.8 or later [Release Number = 528372]
Peak Virtual Memory:
70.1 GB
Private Memory:
558 MB
Peak Working Set:
827 MB
IE Version:
11.789.19041.0
Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Model Default Mode:
Empty
Model Version:
PowerBI_V1
Enabled Preview Features:
PBI_enableWebView2
PBI_sparklines
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_relationshipEditPane
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
150%
Supported Services:
Power BI
Thanks in advance for any help offered.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @red13x ,
No further conclusions can be drawn in my case.
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 _ Caitlyn