Update fail Dataflow due to insufficient space in the disk

[sschweid]

Hello,

I have created a dataflow with several databases. And suddenly the update started to fail because of a single database. I deleted the database and created a dataflow just for it and I still get an update error for the following reason:
RootActivityId = 44f322ec-1844-4a99-9a9e-cd480712b7db.Param1 = PipelineException: There is not enough space on the disk.

I find it strange that it says that I don't have enough space if I have looked at my storage and I have 0 MB out of 10 GB in use in my workplace. All the databases that I manage in the workplace are in the company's Sharepoint.

I hope you can help me, thank you very much!

Regards,

Sara

[tharunkumarRTK · Accepted solution]

@sschweid 

The storage numbers that you are seeing under "Manage Storage" tab is the storage that you get for your Power BI pro license. Generally the results of dataflow gen 1 are stored in a ADLS which you cannot see and it is fully managed by Microsoft.

Coming the issue you are facing, are you using any on prem gateway connection to connect to your databases? If yes then you should ask your gateway admin if there is any disk storage issues on the gateway machine. Or if it is not an onprem connection and its a source cloud connection then I think you should reach out to power bi support team.

I would suggest you to see if there are issues with your datasource and how your queries are running against the db and then contact the support team.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[SaiTejaTalasila · Accepted solution]

Hi @sschweid ,

For more details you can try this reduce data volume(pull only few rows from that db tables),or you can try to run the same m-query on any of your premium capacity workspace and check whether the same issue occurs or not. Even you can try this steps if still you are seeing the same issue after trying the above steps -restart your gateway & services and then try to refresh your dataflow.

And you can open a ticket with Microsoft support incase if none of them helps you to fix the issue.

Thanks,

Sai Teja 

[tharunkumarRTK · Accepted solution]

@sschweid 

The storage numbers that you are seeing under "Manage Storage" tab is the storage that you get for your Power BI pro license. Generally the results of dataflow gen 1 are stored in a ADLS which you cannot see and it is fully managed by Microsoft.

Coming the issue you are facing, are you using any on prem gateway connection to connect to your databases? If yes then you should ask your gateway admin if there is any disk storage issues on the gateway machine. Or if it is not an onprem connection and its a source cloud connection then I think you should reach out to power bi support team.

I would suggest you to see if there are issues with your datasource and how your queries are running against the db and then contact the support team.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!