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

Power Automate failing to refresh Power BI Dataflow or Power BI Dataset. The backend request failed with error code '400'

Good day

I am attempting to create an automation, in a client's tenant, whereby Power Automate first refreshes specific Power BI dataflows and then refreshes the dataset using these dataflows.

I have done this with various clients and tenants with no issue in the past.
However, I am now getting an error code 400 stating that the backend request failed. a bad request.

 

I am using a microsoft profile and Power BI license that was created by the client's IT department.
All credentials are in working order.

Is there a way for Admins to revoke Power Automate / API access to a Power BI tenant?

If so, can someone please point out what specific setting needs to be toggled on/off.

6 REPLIES 6
HarishShades
Frequent Visitor

Is there a solution to this issue? Looks like we are facing this quite frequently. 

How do I get solution to this problem

Hi HarishShades

Unfortunately I have not gotten any solutions from the community as of yet.

I've had to temporarily abandon this route until a fix is found.

jdusek9255
New Member

Same problem - very frequent random failures 

npnigro
Frequent Visitor

I'm seeing this issue too. Does anyone know why this is happening? 

Good day,

 

I was reading through this problem. Usually it comes when business rules for the app/browser/software you often use don't adhere to the rules set. For example, requesting large number of data that exceed the expectation of the system, or sometimes can just be access rights prohibiting the request to run successfully, or error cause by some of the data format. A lot of things can cause this error. The best is to try to investigate the output results of your error.

LebogangMaubane_0-1652363444432.jpeg

 

Kind regards  

I'm currently seeing this when I refresh a Dataflow I have placed in a non-premium Workspace. 
In my premium Workspace I have created a filtered down copy of some data, which I then Link through to the client's non-prem workspace (so they can only see their own data out of a larger pile). 

I tied the Power Automate trigger to refresh based on my current Flow, which triggers every 1 hour. 

I then see this fail ~16 times per day (and work ~8 times per day). 
I believe this is because the max number of Dataflow refrehes in a non-prem workspace is 8 per day - so when Power Automate tries to exceed that the PBI Server comes in and caps. 
It also throws in the occasional random fail so I seem to get 6 good runs midnight to 5am, and the 2 late morning, so it's not in a solid block. But, always around that 16 fails per 24 hour timeframe. 
Cheers, James

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,047)