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

WalterNC
Regular Visitor

@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

WalterNC
Regular Visitor

@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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors