How Power BI integrations with teams fuels a data driven culture
Create quick Power Bi reports in teams && Build an interactive analysis with a conncted Excel workbook to Power bi dataset
How Power BI integrations with teams fuels a data driven culture
Within #teams, we can see the overall workspace including Apps, datasets, the data lineage.
we can choose a dataset to create report in #PowerBI or to analyze it in #Excel, directly in teams, which emprows more users to use data in every decision
How to create an interactive #PowerBI report / build a live pivot tables using Excel woorkbook connected to power Bi dataset
* open the excel workbook connected to the Power bi dataset, and build analysis
* share this workbook using teams, sharepoint, etc
Traditionally this workbooks use #excel desktop to refresh so users needs to download the file to see latest data
New announcements from #Microsoft#Ignite 2021: we can modify the workbook from the web which is refreshable, live and connected to the pb dataset.
Users can make changes to the connected pivot tables, this runs new queries against the #PowerBI#dataset and returns the relevant data.
===> The ability to quickly refresh data in Power bi or Excel in the Web helps users save time over manual export workflows and using the latest data to make decision