Excel File storage location

[jdbusselman]

Our current environment we are utilizing Office 365 and have recently started working with Power BI and deploying reports/dashboards out to Workgroups.  If I have an excel file on my desktop that I connect to in a Power BI report and deploy the report, a dataset gets created in the Workgroup on Office 365.

When I review the Report, it looks like what I've created on my desktop.

For the dataset that was created out in Office 365 that the report uses with the excel data,

• Is the data still in that dataset? 
• If so, where exactly is the data stored if the dataset is out in Power BI on Office 365?

[Anonymous · Accepted solution]

@jdbusselman,

What do you mean that a dataset gets created in the Office 365 Workgroup? Do you connect to the Excel file in Power BI app workspace? If so, currently, creating app workspaces in Power BI create corresponding entities in Office 365 like group workspaces do. You can review this article to get more details.

In addition, when you load data from Excel to Power BI, the data is in the dataset, and Power BI uses two primary repositories for storing and managing data: data that is uploaded from users is typically sent to Azure BLOB storage, and all metadata as well as artifacts for the system itself are stored in Azure SQL Database. For more details, please review this article.

Regards,
Lydia