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.
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.
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.
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.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.