Excel Table from Power BI Dataset Limited to 500,000 Rows

lilianarondon, 

You can in theory modify the DAX/MDX query to increase the row count, though this could have some pretty large impacts on your capacity. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Hi lilianarondon, 

From a blank excel sheet, get data from PowerBI: 

then select your dataset: 

Inserting a PivotTable will use MDX queries (highly inefficient for Fabric as the capacity computes the entire model every time you do anything) 

You can now go to Data -> Queries and connections 

select your connection, and then set the max records to retrieve: 

Inserting a table will use DAX (better for Fabric, I would recommend inserting all the tables and then making a pivot yourself rather than using the MDX pivot)
For the DAX query, you can do the same thing, but you need to modify the query in the definition tab once you get to the connection properties: 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.