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. Using slicer values of Power BI report as query parameters for Paginated report (Concatenated slicers values with Paginated report url and assinged it to action of button for downloading).
For Members of workspace Paginated report works as expected. When a user with viewer tries to download paginated report from Power BI report, facing following error.

Below failed attempts made:
1. Added build permission to dataset.

2. Maintained same privacy levels for both the datasources. In Power BI desktop as well as in Power BI service.

3. I have agg tables to take the load of Direct query data.

4. Tried XMLA endpoint as source for Paginated report.

5. Updated PowerPlatformdataflows datasource credentials.

Thanks in advance.