Forum Discussion
Exceed data limit error after building a relationship to a 17KB file
I have never had any issues exporting data from a visualization until I built a relationship with a new data source (a 17 KB .xlsx). The relationship is linked on a unique identifier, and the data added is a column where each cell contains data seperated by hard return in the cell itself. Example here:
Now when I try to export the data from the visualization, I get the "Exceed data limit error" when I try to export more than 4 rows worth of data. Is there a fix? I don't think the file is large, the most I can export is 5KB worth of data.
1 Reply
- AnonymousNot applicable
Hi burg ,
Try running the data model through DAX Studio or a table editor where you can run best practice checks on the dataset and run performance tests to better understand where it is underperforming and failing.DAX Best Practices | MAQ Software Insights
Measure In Power BI: Optimization Tips And Techniques - Enterprise DNA
Make sure you have the latest version of Power BI Desktop:
Download Power BI Desktop from Official Microsoft Download Center
This is the related document, you can view this content:
Solved: Data exceeds the limit - Page 2 - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.