Forum Discussion
Connected Excel Tables from Power BI as Power Query ?
Hi folks, I got this feature running and it is amazing! DAX seems to be changeable, too! I build some DAX queries in DAX Studio and just pasted them over the one created by the service on export...
Hi JoachimSA ,
You cannot create a DirectQuery / Live connection to an Excel spreadsheet per Microsoft's documentation on Power BI data sources.
If it still does not help, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Alright so that means that I would have to import the tble to a spreadsheet inside the excel and then have power query import that table right ?
If I wanted to go straight to power query inside my Excel file I would have to recreate my online Dataset as a Datamart an then use SQL to query it, right ?