Forum Discussion
Power BI connected PivotTables in Excel for the web
I'm try to use this technique to show a live table of data rather then a pivot table: https://techcommunity.microsoft.com/t5/excel-blog/power-bi-connected-pivottables-in-excel-for-the-web/ba-p/21759...
The addin allows connection to dataverse tables, here is a link:
Then you can use Get Data from Existing Connections to create new tables in different sheets. This solutions allows refreshing in Excel for the Web.
I have tested this as a proof-of-concept only, I'm not sure what challenges you may face in a production environment.
Thank you very much! There are some concepts I'm unfamiliar with... I may need some time to comsume it.
