ADF DataFlow : BadRequest error with any additional information

Question

Hello,

I have a strange error when I only want to use an Excel dataset hosted in ADSL2 as input to a Dataflow.

The preview of the data at the Dataset level is not a problem :

Unfortunately it becomes impossible at the Input stage of my Dataflow. When I try the following error is returned : ( BadRequest - RunId: 0f6aa953-9cb6-4c9a-8670-87ead81ca455 ) without any additional information.

Can you help me?

Thanks in advance,
AV

Answer 1

Hello @HimanshuSinha-msft / @HimanshuSinha-msft ,

I'm facing same problem like @Adrien VLR / @Adrien VLR

When I create the linked service , I already using AutoResolve Integration Runtime like this reference said https://learn.microsoft.com/en-us/answers/questions/1178795/badrequest-error-while-trying-to-test-a-connection

Step :

1. I create the connection and already can preview the data (attachment belows)
   On the file name , I'm using expression format like

   @{concat('dudoo_sales_detail_list_', formatDateTime(utcnow(),'yyyy-MM-dd'),'.json')}

1. And I go back to dataflow, do Connection Test and come out like this
   

How can I resolve this issue ? need your help