Forum Discussion
MarkPHarris1
Helper I
Helper IVisual Has Exceeded available Resources from Powerbi Dataset Source - Solutions
Hi All, I was just wondering if you could offer some advice. I'm currently creating reports linking to a massive Powerbi Dataset(nearly 1gb big pbix file) as a data source. When I create tables u...
Mariusz
Community Champion
Community ChampionHi MarkPHarris1
I think the problem is that you are trying to display too many data points at once, as per error message.
You can look at solutions like drillthrough, this technique will limit the number of records/data points you are looking at one moment and should remove the error.
https://www.youtube.com/watch?v=2x9lLHDbtDk
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
MarkPHarris1Helper I
Helper IHi Mariusz,
Thanks for that, we are already utilising drill through and still generate a table with 5000 rows, purely because of what our data source looks like. Do you think my suggested first changes won't help solve the issue?
Does anyone have any suggestions for not getting this error without premium or filtering in some way? Is it made slower by using a Powerbi dataset as a data source?