Forum Discussion

JoachimSA's avatar
JoachimSA
Icon for Helper II rankHelper II
3 years ago

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...
Need Help
JoachimSA's avatar
JoachimSA
Icon for Helper II rankHelper II
3 years ago

I think you understood it right.

I would like to Query my online PBI dataset using the newly announced connected tables. I like that I can produce a flat table using DAX instead of connecting via Pivot Table using "Analyze in Excel". I found this to become rather slow if you need a lot of columns/dimensions to produce a rather wide flat table. Using a DAX expression seems way more adequate.

I would just like to be able to work with this flat table in power query...