Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 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 🙂
V-lianl-msft
6 years agoCommunity Support
Hi Anonymous ,
If you are a Power BI Premium user, you can solve this problem through incremental refresh.
You can also save data to a database that supports DQ connection mode, and then use DQ connection mode to connect data. SSAS is also one of your options
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.