Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Does anyone have any insight to why I may getting this error? We do an auto refresh of a PBI dashboard through a gateway hosted on a virtual machine. The data comes from a PostgreSQL database hosted on Azure.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_GatewayOutOfDiskSpaceError","pbi.error":{"code":"DM_GWPipeline_Gateway_GatewayOutOfDiskSpaceError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"There is not enough space on the disk.\r\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147024784"}}],"exceptionCulprit":1}}} Table: x.
Cluster URI: x
Activity ID: x
Request ID: x
Time: x
Solved! Go to Solution.
Hi @jamestieu
As per the error your Gateway Server has run out of disk space.
If you could get someone to free up some disk space?
Hi, @jamestieu
According to your error message, I think the refresh failed because the virtual machine that runs the gateway has run out of disk space. It’s because of the spooling process in the gateway workflow. Here’s the introduction to the spooling, you can take a look:
Queries like Power BI refreshes and Azure Analysis Services refreshes can return large amounts of data. For such queries, data is temporarily stored on the gateway machine. This data storage continues until all data is received from the data source. The data is then sent back to the cloud service. This process is called spooling. We recommend you use a solid-state drive (SSD) as the spooling storage.
More info about On-premises data gateway architecture
Therefore,I suggest you to try to expand the disk space in your virtual machine to avoid this data refresh problem. Please refer to this document:
https://www.howtogeek.com/124622/how-to-enlarge-a-virtual-machines-disk-in-virtualbox-or-vmware/
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jamestieu
According to your error message, I think the refresh failed because the virtual machine that runs the gateway has run out of disk space. It’s because of the spooling process in the gateway workflow. Here’s the introduction to the spooling, you can take a look:
Queries like Power BI refreshes and Azure Analysis Services refreshes can return large amounts of data. For such queries, data is temporarily stored on the gateway machine. This data storage continues until all data is received from the data source. The data is then sent back to the cloud service. This process is called spooling. We recommend you use a solid-state drive (SSD) as the spooling storage.
More info about On-premises data gateway architecture
Therefore,I suggest you to try to expand the disk space in your virtual machine to avoid this data refresh problem. Please refer to this document:
https://www.howtogeek.com/124622/how-to-enlarge-a-virtual-machines-disk-in-virtualbox-or-vmware/
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you
Hi @jamestieu
As per the error your Gateway Server has run out of disk space.
If you could get someone to free up some disk space?
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.