Bad Request Error Executing Against a Dataset in PBI Service

(1) Share

Report

Posted on by DM-08090633-0

Hi all,

I've had a flow in Power Automate that has been running once a week without any issues until just now. The issue seems to be coming from a step where I execute a query against a dataset in Power BI Service. The query itself is nothing crazy, just retrieving a couple tables. I've tried deleting and inserting the step again, changing the account the connection is done with, inserting a delay, but nothing has resolved it yet. If anyone has a solution and an explanation as to why this just spontaneously happened, it would be much appreciated, thanks! Here is the error message:

"body": {
        "error": {
            "code": "DatasetExecuteQueriesError",
            "pbi.error": {
                "code": "DatasetExecuteQueriesError",
                "parameters": {},
                "details": [
                    {
                        "code": "DetailsMessage",
                        "detail": {
                            "type": 1,
                            "value": "Query (1, 20) Cannot find table '<oii>Report pages</oii>'."
                        }
                    },
                    {
                        "code": "AnalysisServicesErrorCode",
                        "detail": {
                            "type": 1,
                            "value": "3241803779"
                        }
                    }
                ]
            }

Categories:

Building flows

Power Automate Desktop

Connector development

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

stampcoin 5,171 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@DM-08090633-0 HI,

As you mentioned the flow worked well, I guess it might be power BI capacity overloaded.

You might want to try reduce the fields you need, or try to use TOPN to see if that works or not.

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DM-08090633-0,

The error is very specific: "Cannot find table 'Report pages'". This is not a capacity or performance issue. The table named Report pages no longer exists in your dataset.

This happens when:
1. The Power BI dataset was republished and the table was renamed or removed in the underlying data model
2. The dataset was refreshed from a new source that no longer includes that table
3. Someone modified the Power BI report/dataset and removed or renamed the Report pages table

The fix: open your Power BI dataset in Power BI Desktop and check if the Report pages table still exists. If it was renamed, update your DAX query in the flow to use the new table name. If it was removed, you'll need to either restore it in the dataset or update your flow query to use a different table.

The reason it worked before and stopped now is that someone changed the dataset. The flow query is referencing a table name that no longer matches what's in the dataset.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

This is most likely not a Power Automate issue. The error indicates that the Power BI semantic model has changed since the flow was originally built. The query

executed by the flow is referencing a table called "Report pages" that Power BI can no longer find.

I would start by reviewing recent dataset deployments or model changes and validating whether that table still exists in the current version of the dataset.

Was this reply helpful? Yes No