I have an excel file with 524 records. When getting the records to insert in an sql database I'm just getting 256 limit. I have set the top count to 500, 524, 600 without success. Here is my flow configuration
Could please you check around what is going on?.
Solved! Go to Solution.
check this post
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Depending on your needs, you can use the Static Data connector to bring in up to 15000 records from an Excel file in a few seconds. The resulting table will be read only though.
Hi @RezaDorrani ,
That's it this option was off in the settings. I thought it was enought to set the top count value and didn't imagine this option existed. Now I can get the 524 as expected.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand