PBIX is HUGE!

Hi WishAskedSooner 

Things that normally increase a semantic  model's footprint:

• auto datetime - this creates and invisible dates table for each date column
• datetime- this usually results to a very high cardinality column. Consider splitting them into date and time elements. If you don't need the time, just parse the the date. If you don't need the minutes, just pick the hour. You will want a smaller distinct count of values for each column.
• unneeded columns
• uncessary calculated columns

I would consider using Measure Killer tool to identify elements in your model that can be removed.

https://www.brunner.bi/measurekiller-analytics 

https://www.brunner.bi/measurekiller

Dax studio and vertipaq analyser. This will give you size and cardinality of each tables, column etc

Thanks for the feedback. All good thoughts. It's been a while since I used DAX Studio mainly because I never really needed it until now.

Hi WishAskedSooner ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi WishAskedSooner 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

hi WishAskedSooner few things you can follow to reduce the size
1) Check the unwanted columns delete them and avoid creation of calculated columns if not necessary
2) Check the transformation steps in the Power query make sure steps are query folded 
3) Disable MDX from Tabular editor if its not required it will also reduce the storage

Hi WishAskedSooner 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks