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.

amitjzaveri's avatar
amitjzaveri
Resolver II
5 years ago

Hi,

 

There is a possible workaround if your objective is to analyze the Power BI dataset in Excel.

(For people who see this post and are looking for a solution)

 

1) Login to https://app.powerbi.com/home

2) Open the required workspace

3) Click on the dataset tab

4) Click 3 dots (...) under the required dataset and press "Analyze in Excel"

 

5) Now open the downloaded excel file which will be already connected to the dataset

6) You can also view connection properties in Excel and export connection file for future use

 

 

Hope this helps.  Cheers!

 

Please mark this as a solution in case this answers your question.

  • 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".