PowerAutomate export is not returning all rows from PowerBI using a Dax Query

estebang87 — Fri, 27 Sep 2024 20:42:08 GMT

Hello,

I am running the exact same Dax Query in both PowerBI and PowerAutomate...

PowerBI returns all the correct rows, where as PowerAutomate is missing some.

The total rows returned in PowerBI's Dax Query View is 15923, and PowerAutomate is 13466...

I've checked all filters and settings, and I cannot figure out why there is a difference... any suggestions?

Here is my dax query:

DEFINE

VAR __DS0Core =

Summarize(filter('Backlog + Invoice CO Data', 'Backlog + Invoice CO Data'[Fiscal Year] = "2025"),

'Backlog + Invoice CO Data'[BillToName],

'Backlog + Invoice CO Data'[COItem],

'Backlog + Invoice CO Data'[COLine],

'Backlog + Invoice CO Data'[CONum],

'Backlog + Invoice CO Data'[CONum-Line],

'Backlog + Invoice CO Data'[COStatus],

'Backlog + Invoice CO Data'[CreateDate],

'Backlog + Invoice CO Data'[DelayCode],

'Backlog + Invoice CO Data'[Description],

'Backlog + Invoice CO Data'[DueDate],

'Backlog + Invoice CO Data'[OriginalPromiseDate],

'Backlog + Invoice CO Data'[PMTCode],

'Backlog + Invoice CO Data'[QtyOrdered],

'Backlog + Invoice CO Data'[ShipDate],

'Backlog + Invoice CO Data'[ShipToCountry],

'Backlog + Invoice CO Data'[TotalPriceInUSD],

'Backlog + Invoice CO Data'[Type],

'Backlog + Invoice CO Data'[WHSE],

'Backlog + Invoice CO Data'[Fiscal Year],

'Backlog + Invoice CO Data'[Fiscal Quarter],

'Backlog + Invoice CO Data'[Fiscal Month Name],

'Backlog + Invoice CO Data'[Fiscal Month Number],

'Backlog + Invoice CO Data'[Fiscal Month Number Sort])

EVALUATE

__DS0Core

Re: PowerAutomate export is not returning all rows from PowerBI using a Dax Query

lbendlin — Fri, 27 Sep 2024 21:09:12 GMT

Don't specify the table name again.

Use SUMMARIZECOLUMNS.

Make sure "Include Nulls" is checked.

Troubleshoot with a smaller subset of columns.

Re: PowerAutomate export is not returning all rows from PowerBI using a Dax Query

Anonymous — Tue, 08 Oct 2024 08:46:46 GMT

Hi estebang87 ,hello lbendlin, thank you for your prompt reply!

Is there any progress on this issue?

Please remember to update this thread if you have any progress.

Thank you for your understanding.

topic Re: PowerAutomate export is not returning all rows from PowerBI using a Dax Query in DAX Commands and Tips

PowerAutomate export is not returning all rows from PowerBI using a Dax Query

Re: PowerAutomate export is not returning all rows from PowerBI using a Dax Query

Re: PowerAutomate export is not returning all rows from PowerBI using a Dax Query