I have setup a simple flow that pulls from a Power BI Dataset - I copied the query from the Power BI table that has ~68k rows of data in it. So I setup the Query pull, then do a Select action to format it the way I want it, then a Create CSV Table action , then Email Action to send it out. When I tested it, I only received 32410 records. I went into the Query Dataset action and increased the limit from 501 to 100k. Does it have a limit on how much you can pull at 32410? Any way around this so I get my full dataset?
a different approach - what about saving it to an Excel file and sending out a link in the e-mail? Probably you're hitting some limits on the e-mail body/attachment size etc.
In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.