Some Values Are not Showing in table

[Muthuvel_s]

Hi Everyone 

        Am Having four core rows and 30 columns are there, then day to day adding 40000 rows. but my requirement is that data showing only table format. is it any possible are there ?. 

[v-xiaoyan-msft]

Hi，@Muthuvel_s 

This issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

In this situation, you may need to try to reduce the amount of data in the result currently.

Here are some tips for you to optimize the performance:

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Muthuvel_s]

Hi @v-xiaoyan-msft  
                     Am said that only one month data. But am having two years of data. so what can i do?. can i increase that Time out value sec?.

[v-xiaoyan-msft]

Hi,@Muthuvel_s 

You have to optimize the model even if Your data is built over a period of time.

Please look for and remove columns that have lots of text in them.

Notes fields are a big killer of performance and increases in pbix file size.

Remove columns that are not useful for reporting and analysis.

For more information, you can refer to this : https://www.fourmoo.com/2019/11/27/how-i-saved-40-on-my-power-bi-dataset-size/

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Muthuvel_s , refer if this blog can help

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/

[Muthuvel_s]

Hi
   Am using only power bi Pro Account but you shared that link is power bi premium account holder used on these steps. it's any another ways are there?.