Forum Discussion
How to clear loaded data
Hi , JBDelvaux
Maybe you could try to clear the report cache or change the cache settings here.
file>options and settings>options>data load>clear cache
"Include In Report Refresh" means query is automatically refreshed when you press "Refresh" button on the ribbon.
"Enable Load" means query results are available for report builder. Otherwise you may use it in your other queries (for example to merge data), but it is not shown in the report builder.(Refer to this)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , JBDelvaux
Maybe you could try to clear the report cache or change the cache settings here.
file>options and settings>options>data load>clear cache
"Include In Report Refresh" means query is automatically refreshed when you press "Refresh" button on the ribbon.
"Enable Load" means query results are available for report builder. Otherwise you may use it in your other queries (for example to merge data), but it is not shown in the report builder.(Refer to this)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you. It appear it was indeed the way to go. It didn't solve my problem, but at least now I can tell where it is.
Apparently, for some reasons, my powerbi file is massive (3+ Gb). I assumed at first that it was loaded data, which still might be, but I believe the problem is bigger than that. As I couldn't figure out where all that data was (as I passed the biggest tables in direct query to avoid loading it all), I learned about Dax studio and ran a little query over all my data.
Here's the query:
SELECT dimension_name AS tablename,
attribute_name AS columnname,
datatype,(dictionary_size/1024) AS size_kb
FROM $system.discover_storage_table_columns
WHERE dictionary_size > 0
Funnily enough, the result is that apparently, I shouldn't have that massive file. When extracting the result under Excel and summing the total size, I get 13602 kb. Barely about 13Mb. I feel like my file has simply become bloated and for some reason has lost track of the some of the data. They're saved, but it doesn't know how to access them anymore, bloating the file but the as it can't find them, it doesn't see them.
If my assumption is wrong, please correct me, but I'm going to try and make a new file with the same things in it and see the results.
If my assumpltion is correct, I'll try and place a bug report with my file, and retrace my steps as precisely as I remember.
Thanks for the help