Exporting and importing data in Power Bi

[Ayushman1997]

2 questions to ask.

1. How do I import 350M rows from .csv to Power Bi?

2. How do I export 350M rows from Power Bi to .csv? 

[Shahid12523]

Import 350M rows: Load CSV into a DB (SQL, Synapse, Fabric, etc.) and connect Power BI → don’t load raw CSV into PBIX.

Export 350M rows: Power BI export is limited → use Paginated Reports or export directly from the source/Fabric Lakehouse.

[OktayPamuk80]

However, if you compare the size of the whole records, the 350M will take less space as it has less columns and more repeating same values.

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.

[OktayPamuk80]

Hi Ayushman,

Actually, you don't. But, it depends would be the answer. Why?

• It depends on you data structure (less columns more similar values for a better data compression, so that the data storage is not too much
• Do you really need all 350M records from CSV? That data came from a database, from which you can aggregate  the data to some amount and read into Power BI.
• If you sometimes need detail data, you can create composite data models, where you read in (import) aggreagated data, but have direct query to detail table.
• You will get issues very fast with a Pro license workspace. With a premium workspace you have a little more space
• Here Fabric comes into the game. You can read 350M records into a lakehouse and have direct lake access from Power BI report

Regards,

Oktay

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.

[Ayushman1997]

Thank you very much. Let me try and finish this soon. 

[Ayushman1997]

Hey hi. Niccceeee solution. I get it theoretically. Actually the data was coming from R and the output had only 5M rows. But when I unpivoted the data it became 350M rows which is where the problem of exporting data came in. Hence was looking for some other way. Now I can use lake house to import data and show in visuals and use parameter to show full data in power bi service.