Dataflow Download to Excel Data model error

Question

I have a power pivot data model with a query that combines and transforms some data from a few large CSV files. The query generally runs fine, but it is large and memory intensive on my machine. So, I wanted to outsource the processing to power bi cloud service with a dataflow. So, I have converted the exact same power query steps to a dataflow which runs fine in the power bi cloud service. Additionally, I can download this data into a fresh excel data model with no issue using PowerPlatform.Dataflows()

However, if I try to load it into my existing data model (replacing the old M code with the new code to just download from the dataflow) I get the error:

Column '134217730' is too large for this instance of SQL Server 2016 2016JulMR Analysis Services

I don't understand this because the resulting data after processing the CSV's is identical, the only difference is I am just trying to download the finished product from the cloud service dataflow rather than having my machine and Excel do all of the processing of the CSV's and then load to the model.

Answer 1

Hi Chris-Wagner,

The error seems data types does not match in the finished product. Test the data with small size or different columns may find the cause.
For future analysis, could you share more information on it?

Thanks for your patience.

Best Regards,
Snow Lu