Forum Discussion

JBDelvaux's avatar
JBDelvaux
Helper I
6 years ago
Solved

How to clear loaded data

Greetings, I'm trying to empty all the loaded data. I don't have much space on my computer, and it keeps telling me I don't have enough space. At the beginning, I had ~10gb of data available. Since ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

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.

  • JBDelvaux's avatar
    JBDelvaux
    Helper I
    6 years ago

    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