Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
HI Community,
In the title really, we've been trying out Power BI locally and don't want to publish just yet to ensure data security.
Moving our concept models are has become a little tricky as data loaded into the pbix file inflate the file size greatly (as you would expect).
Is there a way to unload the data but retain the logic required to pull it in again? In this way I can pass the empty file and they can refresh it on their own pc.
Thanks,
Harry.
Solved! Go to Solution.
Yes. Just go to File->Export-> Export to Template. This will create a file that is less than a meg. You can then give it to someone and as long as the source files are on a network drive and they have access to them, they then can load the data.
Yes. Just go to File->Export-> Export to Template. This will create a file that is less than a meg. You can then give it to someone and as long as the source files are on a network drive and they have access to them, they then can load the data.
Thanks so much!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 28 | |
| 27 | |
| 25 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 54 | |
| 46 | |
| 38 | |
| 28 | |
| 21 |