topic Re: Power BI REST API - why does my cloud connector call fail with 'BadRequest'? in Developer

Power BI REST API - why does my cloud connector call fail with 'BadRequest'?

SRJPBI — Thu, 30 Apr 2026 14:50:13 GMT

I have a Power BI report that's been published into the online service. It works fine. I now want to automatically extract data from a matrix within the report.

I have created a flow in Power Automate to do this: I copied the DAX behind the matrix from Power BI's Performance Analyzer, and pasted it into a variable within my flow. I then created a task to use the Power BI REST API to run a query against the report's dataset, setting my variable as the query text.

However, the task gives me this error when I run it:

Cloud connector call failed with status code 'BadRequest'.

Does anyone know why this might be happening and how I can fix it please?

Re: Power BI REST API - why does my cloud connector call fail with 'BadRequest'?

Kagiyama_yutaka — Thu, 30 Apr 2026 16:08:28 GMT

I think the BadReq comes from the visual DAX dragging calc‑lineage the API can’t read,
so keep only the one EVALUATE table that returns rows—if it still breaks, run that line in DAX Studio n see what op won’t fold.

Re: Power BI REST API - why does my cloud connector call fail with 'BadRequest'?

v-ssriganesh — Mon, 04 May 2026 04:17:08 GMT

Hi @SRJPBI,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Kagiyama_yutaka for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

Re: Power BI REST API - why does my cloud connector call fail with 'BadRequest'?

SRJPBI — Tue, 05 May 2026 11:37:07 GMT

This doesn't seem to fix the issue. Here is my original code:

// DAX Query

DEFINE

VAR __DS0Core =

SUMMARIZECOLUMNS(

ROLLUPADDISSUBTOTAL('Table'[Col1], "IsGrandTotalRowTotal"),

"SumCol2", CALCULATE(SUM('Table'[Col2])),

"SumCol3", CALCULATE(SUM('Table'[Col3]))

)

VAR __DS0PrimaryWindowed =

TOPN(502, __DS0Core, [IsGrandTotalRowTotal], 0, 'Table'[Col1], 1)

EVALUATE

__DS0PrimaryWindowed

ORDER BY

[IsGrandTotalRowTotal] DESC, 'Table'[Col1]

And here is what I changed it to:

// DAX Query

EVALUATE

TOPN(502, SUMMARIZECOLUMNS(

ROLLUPADDISSUBTOTAL('Table'[Col1], "IsGrandTotalRowTotal"),

"SumCol2", CALCULATE(SUM('Table'[Col2])),

"SumCol3", CALCULATE(SUM('Table'[Col3]))

), [IsGrandTotalRowTotal], 0, 'Table'[Col1], 1)

ORDER BY

[IsGrandTotalRowTotal] DESC, 'Table'[Col1]

Both versions return the same error.