https://exceleratorbi.com.au/extract-tabular-data-power-bi-service-excel/ This technique allows you to write a DAX Query and run that from within an Excel workbook table with a live connection back to an online Power BI Dataset; i.e. a tabular model. Updated: 10 Nov 2020