Forum Discussion
Power BI Premium Max Intermediate Row Count
Hi Team -- We want to query our Power BI DataSet(XMLA) using DAX and it's ending up with "query to external data source has exceeded the maximum allowed size of ‘1000000’" error. We have increased the Max Intermediate Row Count(2,147,483,647) and Max Result Row Count (2,147,483,647) but it's not working . ((We are using RollUp Operation in our DAX Query)).
Please suggest if there are any alternatives.
Thanks,
Abhiram
1 Reply
Hi abhiram342
Thanks for reaching out to us.
For Azure Analysis Services, the upper limit on the number of rows returned in a DAX query result set can be specified by using XMLA. To increase it, specify the MaxIntermediateRowSize configuration setting. You will need to manually add the entire element to the DAX section of the configuration file. The setting is not present in the file until you add it.
For more details, please refer to this article, Analysis Services DAX properties | Microsoft Docs
Also, here is a similar post for your reference, Solved: Re: The resultset of a query to external data sour... - Microsoft Power BI Community
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
