The query has exceeded the available resources

[YogitaDhuri21]

Hello,

I am importing the 5 million data from lakehouse sql end point, data is imported but in table visual i am facing an issue  i am not able to fetch all the columns in table visual.

can you please suggest what is wrong here. I am using free version.

[rajendraongole1 · Accepted solution]

Hi @YogitaDhuri21 Power BI visuals (like a Table) have a hard limit.Tables and Matrix visuals only render up to 30,000 rows by default.Even if your model has 5 million rows, the visual itself won't show all 5M.

suggestion

Try filtering your Table visual to a small set (for example: Top 1000 rows, or 1 month of data).

Try removing unnecessary columns from your Table visual.

Monitor dataset size: Go to File > Options and Settings > Options > Data Load settings to see memory usage.

Hope this helps

[danextian · Accepted solution]

Hi @YogitaDhuri21 

Showing 5 million rows at once is excessive. Will your users really have time to scroll through that many records?

I recommend adding slicers to limit the number of visible rows, along with a warning that displaying all rows at once could lead to resource issues.

[v-aatheeque]

Hi @YogitaDhuri21 ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @YogitaDhuri21 ,

If our response addressed by the  @rajendraongole1 @danextian is resolved for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[rajendraongole1 · Accepted solution]

Hi @YogitaDhuri21 Power BI visuals (like a Table) have a hard limit.Tables and Matrix visuals only render up to 30,000 rows by default.Even if your model has 5 million rows, the visual itself won't show all 5M.

suggestion

Try filtering your Table visual to a small set (for example: Top 1000 rows, or 1 month of data).

Try removing unnecessary columns from your Table visual.

Monitor dataset size: Go to File > Options and Settings > Options > Data Load settings to see memory usage.

Hope this helps

[kushanNa]

Hi @YogitaDhuri21 , power bi has a 1 million row limit if you are using direct query 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#1-million-row-limit