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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,834)