Forum Discussion

Nikhillearn's avatar
Nikhillearn
Frequent Visitor
5 years ago

uncompressed data size exceeds 10 gb

I am working on a report that pulls data from a database. I am pulling data from a single table of size 1.6GB.  I am able to refresh the report in desktop and get in published. When I try to refresh ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Use DAX Studio to examine your data sources, check cardinality and compression rate. Any cross joins or expensive merges in your data source scripts?

Nikhillearn's avatar
Nikhillearn
Frequent Visitor
5 years ago

Thank you for the suggestion.

I have used Dax studio with this report but no luck. As I said earlier, I am pulling data from a single table, no transformations. I can see that there are some columns with high cardinality but that is justified, these are facts and are supposed to have high cardinality. What I don't understand is why 1.6 GB in database which becomes 360 MB in Power BI is exceeding 10 GB limit on gateway.