Forum Discussion

manideep547's avatar
manideep547
Helper III
6 years ago
Solved

Reduce size

Hi All, can anyone suggest me how to reduce my dataset? My .pbix is nearly 1 GB  and I am using SQL server, import mode.  Thanks&Regards, MANI DEEP.
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi manideep547 ,

     

    You could create a view in your sql server based on useful columns. If your file size is still big, you could try direct query mode. it will not save your data in pbix file.

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Bring the only needed data rows and columns.

Provide more information.