Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I'm using the PowerQuery Extension API (NOT Power BI Desktop) and I have the following function:
shared PQDeiworld.Contents = (url as text, DEINSP as text) =>
let
DEIPass = Extension.CurrentCredential()[Key],
query = [
DEINSP = DEINSP,
FlagIdiomas = 1,
DEIPass = DEIPass
],
answer = Text.FromBinary(Web.Contents(url, [Query = query]))
in
answer;The response to this from the (internal) web server is a slightly malformed XML Document, that I know how to clean up in PBI Dekstop.
When I try to run the extension in Visual Studio, I get the following response:
Unexpected Exception
Details:
[DataFormat.Error] We found extra characters at the end of the JSON Input
I'm not telling Web.Contents to parse JSON, I want to get the binary out, and parse it myself - how do I stop Web.Contents from doing so?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |