Hello,
I am trying to pull Dataset tables using Power Query.
There is this new feature that allows you to pull Dataset tables into Excel:
https://powerbi.microsoft.com/en-us/blog/announcing-new-ways-to-create-connected-tables-in-excel-connected-to-power-bi/
but it uses the “legacy” connections, instead of Power Query
This connection is blazing fast, it loads 100 000 rows in just a few seconds.
I would like to pull this table directly to Power Query so that I can then do some more data transformation while using this fast connection capabilities.
Any ideas on how to pull this data into Power Query ?