Error when refreshing: "There is no enough space for this row."

[bloigge]

Hi,

When I try to refresh my data I get this error: "There is no enough space for this row." What does this mean? Is my data model too big?

[hsumal]

I am getting this error using the online refresh and scheduled refresh . My data model is very small (2mb). Has this been resolved ?

[mdoll]

Having this same issue.  Not sure how I am supposed to decrease the size or get it to refresh.

[rodjarman]

Bumping this post as getting the same error.

It is quite a large file. Not sure how to measure it but it is around 95Mb as a .pbix file.

Other data sets update fine so could it be a capacity issue with the gateway? 

[rodjarman]

Update: Data model is 101,540 Kb.

[Anonymous]

This is an issue for us too - refreshing data via R and Power BI gateway, I get the rather Scottish sounding - "There is no enough space for this row."

My file size is 101 MB, works fine on desktop of course.

What's strange is apparently Power BI increased their limits fairly recently ...

https://powerbi.microsoft.com/en-us/blog/power-bi-service-may-update-file-size-increase-to-1-gb/#one...

And we should therefore be good up to 1 GB .... but we're not.

Anybody have any ideas why it fails?

[Wouter]

Any news on this one. Getting the excact same error.

Extra Comments: Worked initially

[Seth_C_Bauer]

@bloigge depending on what you are using to create your model, this blog should help you out. It will show you how to determine the size of you model.

[bloigge]

@Seth_C_Bauer - Thank you for your feedback. I zipped my powerBI desktop file and it seems that the size of my data model is small enough. Any thoughts why I stil get the error?

[Seth_C_Bauer]

@bloigge Let's back up a second. I posted based on the "Is my model to big" question.

Where and when are you getting the error specifically. Have you changed anything in your model recently?

[bloigge]

My report is new - the model was created recently - I was never able to refresh anything. The error is shown when I click "refresh now" in the PowerBI.com Dataset section. The data is retrieved from an on-premise data source via the gateway. When I use the same M-Language Code in PowerQuery in Excel I can refreh with no error.

[Seth_C_Bauer]

@bloigge I'm not familiar with the exact error, I can hypothesis that it has something to do with a data/field length ( for obvious reasons) Do you have any excessively long column names or possible data values?

While I'm not aware of any hard limit, it doesn't mean that there isn't one.

Other things to try:

Ensure that your data sources are supported: https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi

Try to run the model through Power BI Desktop and publish

use the "Frowny face" in PBI Desktop to submit the issue if it still occurs to get more directed support to troubleshoot.