The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have created a .pbix file whose data was loaded from a .csv file. I have added custom columns and measures to the only defined table. I now want to replace the .csv file with a new instance of it, so I thought I would create a .pbit file, open it, and populate it with the new .csv. I selected File | Export | Power BI Template and the .pbit file that was created is much smaller than the .pbix, which I assume is because the .pbit file does not contain any data. However, if I open the .pbit file, the data populates. I assumed when I opened the .pbit file that no data would exist.
Can anyone provide insight as to what I have done wrong or need to do to not have data populate when I open the .pbit file?
Thanks!
Hello @Jeff2Jets ,
Also for more info, you could refer to this solution https://community.fabric.microsoft.com/t5/Desktop/What-is-the-difference-between-pbix-and-pbit/m-p/8...
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Jeff2Jets you should create a parameter for the csv file and use that parameter as a source to get the csv file. Save as .pbit and now when you open the pbit file it will ask for the csv file and at that point, it will read the data from the file that you will provide in the parameter value.
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |