Use Power BI Data Table in Excel

[Anonymous]

Hi guys,

so i a data table in power bi which i got by combining different SQL queries and transforming them in power bi. Now i have this final data table that i want to push to Excel because we need to be able to work with the data table in Excel due to different reasons. 

How can i push this final data table from power bi to excel? I would need it ideally in some automated way so i can refresh the power bi table from excel. Basically like if you would include just a SQL table in Excel and refresh the query. 

Appreciate!

[pranit828]

Hi @Anonymous 

There are few ways, but have you explored the option to use Power BI Direct query.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

[az38 · Accepted solution]

@Anonymous 

You could create dataset in Power BI service and then use ANalyze in Excel option