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
finarne
New Member

Beginner questions on how PowerBI "imports/copies" data from source to service

Hi,

 

Apologies in advance if this information is available elsewhere.

 

I am starting out with PowerBI and have a few (hopefully simple) questions.

 

Scenario: simple reporting on a small csv file (<100kb)

If I have a small csv file that I want to use for reporting, when I connect to this csv file does PowerBI "import" the entire file contents to the PowerBI.com service?

 

My understanding is that the quota I have available with say the PowerBI Pro license is 10GB per workspace, if I have a csv file of 100KB will this 100KB be imported in its entirity uncompressed or does PowerBI do some sort of smart compressing to the workspace?

 

If I want to connect to a much larger data source (say an Azure Table Storage) that is 5GB in size, will the act of connecting to this data source cause PowerBI to start importing the entire data source from Azure Table Storage to the PowerBI service...or does PowerBI only import a "smart" portion of the Azure Table Storage?

 

I am trying to understand the end-to-end concepts of how data that I want to report on is imported or copied into the PowerBI service. I am trying to understand if I have a large data source will it take some time for it to be copied/imported into PowerBI or is there another concept to how PowerBI "connects" to the data source for reporting.

 

I am trying to understand how to calculate the amount of space a data source will consume out of the quota a workspace has available.

 

In terms of data refreshing, how does this work? Does PowerBI have a incremental refresh of data sources, or does it simpy re-import the data source in its entirity again?

 

Thanks in advance for any guidance you can provide, I am sure some of these questions will prompt other questions or maybe can be simply answered with a link.

 

Colin

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Yes, Power BI generally imports data unless you specify a "live" (Direct Query) mode of connecting. Yes, Power BI super compresses the data using columnar compression. Difficult to estimate how much compression you will get as that depends on the data.


@ 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...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

Yes, Power BI generally imports data unless you specify a "live" (Direct Query) mode of connecting. Yes, Power BI super compresses the data using columnar compression. Difficult to estimate how much compression you will get as that depends on the data.


@ 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...

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