Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 timeframe) which I don't expect to get orders of magnitude larger but won't comfortably fit under that limit any time soon.
I'm wondering if there's a way to save my PBIX file so that it keeps all of the queries currently used, but doesn't store all the actual data inside the file? e.g. in the manner of how, when you recover a recently autosaved version of a file, it doesn't have any data, and you have to click Refresh to download it all again.
I would love to be able to save and publish my report like this, and then have the auto-refresh gateway send all the data through after publishing.
Solved! Go to Solution.
Hi @jorio,
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 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi @jorio,
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 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
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.
Hi @jorio ,
Power BI have two option to connect your data.
1. Import Mode
2. Direct Query or Live Connection
In your case, power bi used import mode type to read/import your data from your source. try to use incremental refresh to add new data instead load entire data from your source.
or, I recommend to use direct query / live connection but there's a certain limitation interms of connecting to the source.
Thank you.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |