cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

DataSource.Error: Web.Contents failed to get contents from (400): Bad Request

Hi there,

 

I am trying to get my power bi dataset in a CSV using Flow/Power Automate.

I used this blog www.thebiccountant.com/  to create the query and the flow but i get DataSource.Error: Web.Contents failed to get contents from (400): Bad Request when i add the last step of the flow.

 

When a HTTP request is received =>

Compose using Json(decodeBase64(triggerBody()['$content'])) =>

Create CSV File 

Up to this stage my query:

let
Source = OData.Feed("https://XXXXXXX),
ToArray = Table.ToRecords(Source),
ToJsonBinary = Json.FromValue(ToArray),
WebCall = Web.Contents("https://prod-180.westeurope.logic.azure.com:443/workflows/XXXXXXXX", [Content = ToJsonBinary]),
LinesFromBinary = Lines.FromBinary(WebCall)
in
LinesFromBinary

Works but asoon as i add the Create File step in my flow i get the error DataSource.Error: Web.Contents failed to get contents from (400): Bad Request in my power query

 

What am i doing wrong please help

1 ACCEPTED SOLUTION

I fixed my problem 😀

 

I end my flow with HTTP that sends it to a new flow where i create my file on onedrive

This is what my flows look like:

 

To create the CSV:

WalterNC_1-1599829476074.png

 

To save it too onedrive:

WalterNC_0-1599829432843.png

 

View solution in original post

6 REPLIES 6
Super User IV
Super User IV

@ImkeF @edhans 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @WalterNC ,

you have to use a tool like Fiddler to analyse what's being sent from Power Query and compare that with the requests from your endpoint (flow).

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

@ImkeF 

 

When i use fiddler i get {"error":{"code":"InvalidRequestContent","message":"The input body for trigger 'manual' of type 'Request' must be of type JSON, but was of type 'application/octet-stream'."}} as an error back

Hi @WalterNC ,

sorry, but I don't have more ideas here.

If you used the code provided with the "Json.FromValue" as the last function before putting it into the body, there must be something wrong with that function, actually.

But I don't have time currently to dig deeper into it, unfortunately.

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

@ImkeF 

 

At thebiccountant they add outputs('Compose')['BinaryContent'] to the Create CSV but im not allowed to add ['BinaryContent'].

I get the error The template language expression 'outputs('compose')['BinaryContent']' cannot be evaluated because property 'BinaryContent' cannot be selected

 

Might this be the problem?

 

I fixed my problem 😀

 

I end my flow with HTTP that sends it to a new flow where i create my file on onedrive

This is what my flows look like:

 

To create the CSV:

WalterNC_1-1599829476074.png

 

To save it too onedrive:

WalterNC_0-1599829432843.png

 

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors