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 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is 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.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 28 | |
| 23 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 44 | |
| 32 | |
| 18 | |
| 17 | |
| 17 |