Forum Discussion

Landcrab's avatar
Landcrab
Helper I
5 years ago
Solved

Connect Excel to Power BI Dataset

Hi there,   Wanting to use the 'Get Data' from Power BI Dataset in Excel as descripted in below image and article:     Other ways to access Power BI datasets from Excel        But I don...
Need Help
  • Landcrab's avatar
    Landcrab
    5 years ago

    Having installed the Office Insider build means I now have the ability in Excel to connect directly to a Power BI dataset.

    Thanks everyone for the other great suggestions, much appreciated.

RobertSlattery's avatar
RobertSlattery
Responsive Resident
5 years ago

Hi, this only seems to allow connecting to pivot tables, how to query a table like, EVALUATE TableName?

JentonBI's avatar
JentonBI
Frequent Visitor
5 years ago

RobertSlattery Once you have a pivot table with a measure in it, if you double click a value, it will create a connected "drill through" table on a new tab. You can then go into Connection Properties of that table and on the Definition tab change the command text to a DAX table query, like your example of "EVALUATE TableName".