cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pkoel-asb
Helper IV
Helper IV

When I import a data source - where does that data go?

Hi,

 

   I am a new Power BI user. When I import from a data source, where does that imported data go, and how long does it stay there? I do not beleive it resides in the dataset.  I have seen informaiton that is goes to a Azure Blob Storage. I found this article: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-power-bi-security It is very confusing for a new user and does not talk about the life-span of the BLOG or what happens when the dataset is re-freshed: is the BLOG ower-written, or is a new BLOG created. If a new one is created, what happens to the old one?

 

Cheers,

 

Peter

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

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

     

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

5 REPLIES 5
aj1973
Community Champion
Community Champion

Hi @pkoel-asb 

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.

  

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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

aj1973
Community Champion
Community Champion

@pkoel-asb 

Sorry didn't understnad your question!

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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

aj1973
Community Champion
Community Champion

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

     

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors