Exceed data limit error after building a relationship to a 17KB file

[burg]

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.

[Anonymous]

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.