Connect Excel to Power BI Dataset

[Landcrab]

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 dont see that option in Excel under 'Get Data', I have an E3 SKU and Power BI Pro license assigned, From Power BI Service the 'Analyze in Excel' option works, I just don't see the option to connect directly to a Power BI Dataset from within Excel which is what I want 😞

Anyone know how what the problem is and how to fix please?

Further down the page, Microsoft's requirement description seems to indicate having a Power BI PRO license gives access to this feature..

[Landcrab · Accepted solution]

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]

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]

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

[JentonBI]

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

[Greg_Deckler]

@Landcrab - It appears that this was a feature of Power BI Publisher for Excel. That product has been retired/deprecated.

https://community.powerbi.com/t5/Community-Blog/How-to-enable-Excel-Pro-s-to-use-Power-BI-Datasets/b...

https://community.powerbi.com/t5/Service/Power-BI-Publisher-for-Excel-Retired/td-p/939988

[Landcrab]

Thank you @Greg_Deckler  - you are absolutely right! That feature has been deprecated, but the other below mentioned option of using Office Insider Build works for me.