Forum Discussion
compress dataset
Hello Community, I have a Dataset used by a user who every time create new measure or update something in the power query, would refresh the dataset on the desktop and then publish it. The D...
Phil_Seamark that is a long term option which am working on. at the moment I have MYSQL DB which are a bit messy and I don't have the enough resources to structure views in there.
Guess I will have to try and go on another round of removing unrequired columns...
Cheers mate
Columns that have unique values are good ones to target. If you can get rid of these then your ability to compress will be improved.
Also if you can pivot data to be vertical rather than horizonal, this will help