The CSV file created using Power Automate is empty

[MgLina]

Hi all,

I need your help, I have a flow that was working perfectly before, I use this flow to export previous month's data (current month - 2) from a power bi report every month and create a csv file and save to sharepoint.

But for this month's data, I don't understand why the csv file created and saved in sharepoint is empty and I checked the flow result that the output of the "Create CSV table" action contains the data. I tried a lot of things and searched the forum for solutions, but couldn't find anything for this type of problem.

Here is the flow result:

Here is the details :

Could someone please help me?

Thank you for your support !

@FLMike @Matthy79 @Expiscornovus @wskinnermctc @Pstork1 @LinnZawWin @trice602 

[wskinnermctc]

How many times did the Do Until loop run? 

The Do Until might have run more than once.

Can you show the results of the Do Until? I am unable to see them in your screenshot.

[MgLina]

Hi @wskinnermctc , Thank you so much for your reply,

Here is the screenshoot, the Do until ran 12 times or 60 times for the flow send the file empty.

or

This is the Do Until result from the flow worked well before.

I don't understand why before it worked perfectly, but now it didn't work anymore..... 

Thank you for your help !

[wskinnermctc]

The previous flow that was successful made 60 different files?

Do Until shows 1 of 60 and there is a Create File action. So I'm assuming 60 files were created?

I don't understand if you are making a monthly report, but 60 files are created.

[MgLina]

Hi, i use the Do Until action to be able to export more than 100k rows in one file. Here is the video that i follow to create the flow. Because with the power automate limitation, more the columns you have, less the rows you get.

Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits! - Bing vide...

So i just get one csv file each time the flow runs. 

[MgLina]

Hi, it's very wired, i just did a test, when i use the action "Create file (One drive)", it works, the csv file has the content. But not with the action "Create file (sharepoint)".

Do you have any idea ?

Thank you

[MgLina · Accepted solution]

I fixed it. I just deleted the action "Create file (sharepoint)" and create a new one, it works again. 

Still don't know why, may be a bug from power automate 🤔.

Thank you @wskinnermctc for spending your time on my topic, it's very appreciated 😊

[wskinnermctc · Accepted solution]

Your example shows the Create File inside of the Do Until.

The video shows Create File after the Do Until.

It has to be creating a new file and overwriting it 60 times.

[wskinnermctc]

I'm glad you have it working. But I still think you need to double check the files. Your example is not the same as the video. Maybe you know that and did it for a reason.

From my perspective your file is getting re-created 60 times. And I don't see how the rows are getting combined like the video example.

[MgLina]

Yes, you are right, i don't know why i did't finish my flow according to the video 😂. But when i create exactly the same flow like video today, it still didn't work. So the solution i find, it's to delete the Create file action, et create a new one. I think there is a system bug.

[wskinnermctc]

I think you need to check the file and see if it has more than 100,000 rows like you expect. 

[MgLina]

Thank you for your comment, until now, i didn't have more than 100k rows yet, just only 350 rows. I will check on it.