Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Not Save Dataset in PBIX File?

I'm currently working on a PBI report which recently started pushing the 100MB size limit imposed by our source control solution. This is mostly one huge table (already trimmed down to the minimal ti...
Need Help
  • dm-p's avatar
    dm-p
    6 years ago

    Hi Anonymous,

    Whether you're using DirectQuery or Import, you can save the workbook as a report template. This will save the file with all connection info, but no data. When the file is opened, it will need to load in the data before you can work with it but is a great compromise if you're using source control to store the file.

    Regards,

    Daniel

    If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂

dm-p's avatar
dm-p
Super User
6 years ago

Hi Anonymous,

Whether you're using DirectQuery or Import, you can save the workbook as a report template. This will save the file with all connection info, but no data. When the file is opened, it will need to load in the data before you can work with it but is a great compromise if you're using source control to store the file.

Regards,

Daniel

If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you!! The other responses' suggestion of incremental refresh seemed to be relevant but templates are exactly the solution I was describing in my post.