cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted

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
Highlighted
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!




Highlighted

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

Highlighted

@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

Highlighted

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

Highlighted

@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?

 

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors