Forum Discussion
When I import a data source - where does that data go?
It doesn't matter how many million records your database contains. What matters is how much data you use to build your report (After ETL). This late data is stored in the Dataset. If you have a pro License the Dataset can't be bigger than 1GB in order to publish it to the service into a workspace. Every workspace can hold up to 10GB of datasets. these dataset from the workspace are stored in Azure Blob.
I hope the picture is clear now!
Let me know
Hi Anonymous
The link you provided is taking to a different planet lol. why can't you beleive that your imported data resides in the dataset. Once you finish building your report you will publish it to Power Bi service and the dataset will then be saved to Azure Blob Storage https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi. when the dataset is refreshed it will be overwritten, no creation for a new Dataset.
Hello,
Thank you for the reply. Thank you for the link as well. Does the data set just reference the actual storage location in the Azure Blob?
Cheers,
Peter
Anonymous
Sorry didn't understnad your question!
Hello,
Thank you again for the fast reply. I have a 50 Million record database. When I publish a Power BI desktop application, is the 50 million records stored in the data set, or is the 50M record stored in the Azure Blob? If it is stored in the Blob, does the published data set just act as a reference to the Blob?
Sincerely,
Peter