Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.