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