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.
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,
Solved! Go to Solution.
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
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
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.