Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Power BI connection issue with Decipher through API. We have been using this coonection type since last 4 years. I faced below error from 30th Jan'25. How to resolve error "OData: The format 'application/xml; encoding=utf-8' is not supported". It is reply from Decipher end "For the error you are seeing, that looks to be from the Power BI tool/page. In my testing, I was able to use the API call from the data downloads to successfully make the call to the survey."
Hi Folk,
Plz provide a proper solution. It is still not resolved.
Hi, @praphull
I think header has a typo, encoding= instead of charset=. In power bi, OData Connector, it relies on the API’s Content-Type header to parse the response. Try append $format=application/xml;charset=utf-8 to the URL to force the correct format, If you prefer the OData connector.
You could also, bypass the default OData connector and use the Web Connector instead to manually parse the XML.
First fetch the raw response as binary (ignoring the Content-Type header), then convert the binary to Text using UTF-8 encoding and then parse the text as XML. Here is an example (Power Query):
let
// Fetch the raw response as binary (ignoring the Content-Type header)
Source =
Web.Contents("https://api.decipher.com/your-endpoint", [Headers[Accept="application/xml"]]),
// Convert the binary response to text using UTF-8 encoding
ResponseText = Text.FromBinary(Source, TextEncoding.Utf8),
// Parse the text as XML
ParsedXml = Xml.Tables(ResponseText)
in
ParsedXml
If the API requires authentication or other headers (e.g., API keys), add them to the Web.Contents function:
Source = Web.Contents(
"https://api.decipher.com/your-endpoint",
[
Headers = [
Accept = "application/xml",
Authorization = "Bearer YOUR_API_KEY"
]
]
),
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |