Data Flow Error: Your mashup exceeded the maximum length allowed by this service and cannot be saved

edhans 

I mean I have 100+ Sharepoint lists from different Sharepoints (e.g. Sharepoin Project A, Sharepoint Project B, etc.). Each list is standardized so each columns contain the  same data category and type. 

What I do is compiling all of these Sharepoint Project ... lists in PowerBI desktop using Append method into 1 common table Experience Sharing Table (see the picture below where I compile 80 different project Sharepoint..).

It starts to getting slow when I add around 20 Sharepoint list, it's getting worse and always crash after waiting for hours when adding more than 80 lists. I Also have unchecked "Enable load" to reduce the load and only the common table which is loaded to the Dekstop. 

So I use Data Flow instead as suggested by other. The method is the same by appending all the lists into 1 common table,  but turn out with error message when connecting/adding Sharepoint list no.30. There will be more than 100+ Sharepoint lists that need to be compiled, and the number will grow gradually).

Is there any work around to handle this?

Or how to solve the error issue above?

Best regards,