Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |