To connect to a dataset, users must also have build permissions to the dataset. If users have published datasets to their “My workspace”, they can also connect to these datasets from Excel. This is very useful during model development.
#ANALYZE IN EXCEL FOR POWER BI DESKTOP PRO#
Previously, accessing Power BI data directly from Excel (Desktop or Web) required a Power BI Pro or Power BI Premium Per User (PPU) license. This way, you can both connect to the model from Excel, from Power BI Desktop, and you could even have reports and dashboards in Power BI cloud without having your data in the cloud.
This helps organizations who use Power BI Premium to easily distribute authoritative datasets broadly with their users via Excel. The better way to do this, if you cannot use the Power BI cloud platform, is to deploy the model on SQL Server Analysis Services Tabular. We are excited to announce that in the coming weeks we’re expanding the availability of Power BI and Excel connected features such as PivotTables from Power BI datasets and Organization data types to Power BI free license users.
0 kommentar(er)
