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?
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?
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 ...
And we should therefore be good up to 1 GB .... but we're not.
Anybody have any ideas why it fails?
@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?
@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?
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.
@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.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.