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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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?


@ 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!:
Mastering Power BI 2nd Edition

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors