Forum Discussion
Use Power BI Data Table in Excel
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!
Anonymous
You could create dataset in Power BI service and then use ANalyze in Excel option
2 Replies
- az38Community Champion
Anonymous
You could create dataset in Power BI service and then use ANalyze in Excel option
- AnonymousNot applicable
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