March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have a huge uncertainty of how the "Publish" button on Power BI Desktop application works.
If I create a report on Power BI Desktop via a local file(.csv) and then proceed to hitting "Publish":
I would not think I would be publishing 3GBs of into to Power BI.
Thanks.
Power bi desktop ingests a full copy of the data. The connection is no longer needed (unless you want to refresh the data). The copy of the data is sent to the power bi service along with the model and the visualisations.
There are 2 modes for Sql server. You can use direct query mode (data stays in the server locally) or import mode (data is copied just like csv files).
It is unlikely that you would need 3gb of data copied to a power pivot workbook. I have a 60gb sql database that loads to 300mb by the time I have loaded just the data I need and also the compression has done its job
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |