Forum Discussion
There was an error communicating with Analysis Services + Maximum size allowed size of 1000000 rows
I have created a paginated report using Power BI dataset which has a composite model Direact Query (Dataflows) and Import Mode (Snowflake) and enabled deafult download of Paginated report to excel. ...
lbendlin
Super User
Super UserUse less data. Remove unnecessary joins. Reduce the cardinality of the join columns.