-->
Like what you read earlier, what normally happens is that you import data from Excel to Power BI as an.xlsx or.csv file to run insights and analytics on it. However, there could be reasons why you would want to export data from Power BI. Some of these include: Double-checking the actual data but you don’t have access to the data sources. Great Cloud-based features: Power BI (Pro) is made for collaboration. Unlike in Excel where you’ll have to email the file around or in a portal, Power BI makes it easier. There’s a cloud service called “Power BI Service” where you can publish your data. Furthermore, this service automatically refreshes your data.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users, automatically | Aug 3, 2020 | Oct 31, 2020 |
Feature details
Certified and promoted datasets in Power BI provide organizations with a mechanism to distinguish their most valued and trusted datasets. Today, Power BI users are able to analyze this data in Excel by using a live, connected experience. We’re adding a new way to connect to certified and promoted datasets that will make it easier for all Microsoft 365 E5 users to find, connect, and analyze data from these datasets directly from Excel.
See also
Power Bi For Excel Users
Power Bi For Excel 2013
Simplifying enterprise data discovery and analysis in Microsoft Excel (blog)