Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Export huge amount of data from one pbix-file and import in another one

Dear all, I'm struggling with a serious problem. I have a database in Power Bi with a significat amout of data collected from different sources related to Bdg 17. Now that we are preparing a new database for BDG 18 I need to export data from the previous one, for the main table, and import in the BDG 18 one. I read this post https://community.powerbi.com/t5/Integrations-with-Files-and/import-data-from-other-pbix-file-into-t... but it is not suitable for me because the number of records. I thought that the new feature of this month (connettor to Power BI Service) could come to help me but seams that it is not possible modify tables, upload new ones or create new mesures. Are there any ideas or am I misleading something?? Thanks a lot for your help!!!
2 ACCEPTED SOLUTIONS
cwebb22
Advocate II
Advocate II

In follow up, you might also try using R to export the data from your .pbix file as explained here: https://community.powerbi.com/t5/Community-Knowledge-Base/Export-dataset-into-a-file-from-Power-BI-D...

View solution in original post

mim
Advocate V
Advocate V

you can try this, it is using powershell, i tried it myself with 8 millions rows, and it worked.

 

https://github.com/djouallah/PowerBI_Desktop_Export_CSV

 

cheers

View solution in original post

5 REPLIES 5
mim
Advocate V
Advocate V

you can try this, it is using powershell, i tried it myself with 8 millions rows, and it worked.

 

https://github.com/djouallah/PowerBI_Desktop_Export_CSV

 

cheers

cwebb22
Advocate II
Advocate II

In follow up, you might also try using R to export the data from your .pbix file as explained here: https://community.powerbi.com/t5/Community-Knowledge-Base/Export-dataset-into-a-file-from-Power-BI-D...

Greg_Deckler
Super User
Super User

Perhaps I am missing something, but why not just create a copy of the PBIX file?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi Smoupre, thanks for your reply but, if it was so easy I would't ask PBI Community... 😉
This database is 500 mb and don't want to carry over all the data, I just need the data of the main table ( there are 20 tables in this PBIX file...), and for sure I dont what to add any other mb to the same PBIX.
Hope this clarify, thanks!!

Is your requirement to get data out of Power BI .pbix file? If so, and you can open the .pbix file, you should be able to copy that data into excel by navigating to the query editor view, copying your table, and exporting to a .csv format.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors