Analyze in Excel Error: while attempt to store a string, a string was found that was larger than

[Anonymous]

I have a dataset in Power BI service, I click the analyze in Excel in the dataset and a file was downloaded, 

When I open the excel file and a model content is visible, When I select a column from the model,

I got the below error, Could you please help to check why this is happen, Few days ago, it works well. Thanks so much for your response in advance.

[v-henryk-mstf]

Hi @Anonymous ,

Maybe it seems the problem is caused by the OleDB driver.

You can read below similar solution and related document:

SSAS Error : Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed.+ Solution (surendrathotamsbiproffesional.blogspot.com)

Troubleshooting Analyze in Excel in Power BI Desktop - Power BI | Microsoft Docs

If the problem is still not resolved, please provide more information and error screenshoot. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.