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

[estebang87]

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

[Anonymous]

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.

[lbendlin]

Don't specify the table name again.

Use SUMMARIZECOLUMNS. 

Make sure "Include Nulls"  is checked.

Troubleshoot with a smaller subset of columns.