Forum Discussion
Solved
Connect Power Query to Power BI dataset from Excel
I'm trying to access a Power BI dataset via Power Query, with the end goal of being able to bring selected data into Excel from a huge Power BI file. I'm aware of the ability to connect Excel to...
No. Connecting to a Power BI Dataset will just allow you to create a pivot table with slicers in Excel. Power Query doesn't even know of its existence. If you go into Power Query in Excel, there is no "Power BI Dataset" connector in the "New Source" menu.
Bummer, I was hoping there was a less-obvious way in. Thanks for the quick response.