Power Platform Community Forum Thread Details

Export Power BI data to Excel / CSV (NO row limits) - Curbal Video

Hi Everyone - I'm new to Power Automate and I'm trying to improve my Flows!

I have successfully implemented previous Curbal videos where small file downloads can be automatically triggered using a Flow.

I have tried to get this blog/video to work:

https://curbal.com/curbal-learning-portal/export-more-than-100k-rows-of-power-bi-data-to-csv-using-power-automate

In the Flow it creates a Loop count.
I get this error when it tries to run the Do Until

InvalidTemplate. Unable to process template language expressions for action 'Do_until' at line '1' and column '10985': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Integer' and 'String' that do not match.'.

My dataset is called 'PayrollData' but everything else should be the same as the Curbal blog.

At "Run a query against a dataset 2" I altered the ROUNDUP for 0 places (did not solve the issue):

EVALUATE
ROW(
"loopsNeeded", ROUNDUP(
CALCULATE(DISTINCTCOUNT('PayrollData'[Index]))/25000,0)+1
)

Outputs:

[

{

"[loopsNeeded]": 85

}

]

At "Loops2Run" this is my code:

outputs('Run_a_query_against_a_dataset_2')?['@{body('Run_a_query_against_a_dataset_2')}/@{outputs('Run_a_query_against_a_dataset_2')?['body/firstTableRows']}']?[0]?['[loopsNeeded]']

And Output - it is a floating point integer?:

outputs('Run_a_query_against_a_dataset_2')?['{"results":[{"tables":[{"rows":[{"[loopsNeeded]":85.0}]}]}],"firstTableRows":[{"[loopsNeeded]":85.0}]}/[{"[loopsNeeded]":85.0}]']?[0]?['[loopsNeeded]']

And then the error message occurs for Do Until.

I'm not sure if someone I need to Initialise loopsNeeded as an integer.

It wasn't part of the blog or video.

Any suggestions welcome 🙂

Thanks in advance.

Quick Links

Leaderboard