Forum Discussion
Some Values Are not Showing in table
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 ?.
5 Replies
- amitchandak
Super User
Anonymous , refer if this blog can help
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
Hi，Anonymous
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.
Hi,Anonymous
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.
