cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshua1990
Super User
Super User

Curate featured tables for Excel

Hello everybody!

I would like to add the new feature of "Curate featured tables for Excel" into my Excel.

I have updated the Power BI Version, set the "feature table" for the corresponding Table, and published/ refreshed the whole Power BI.

I have also installed the Analyzer for Excel.

Now I can't see any new data types in Excel like here:

042720_1708_PowerBIDesk1.png

What have I missed?

8 REPLIES 8
RomainSyn
Helper I
Helper I

Hello,  

I have it working on my excel (recent version).
However, I was hoping it would work on premium environment without power bi Pro license. So far no success.
Anybody experimented it with premium?

Anonymous
Not applicable

Hi Power BI gurus!

 

I have the same issue as mentioned above - the only icons I see in "Data types" are Stocks and Geography. Maybe this is dependent on Excel verison? I am using 1908.

 

I'm looking forward to see your experience with this new feature - it seems amazing, so I would really like it to work!

 

Best regards,

Karol

Read: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-excel-featured-tables

 

This article in section "Licensing" says:

 

The Excel Data Types Gallery and connected experiences to Power BI featured tables is only available for Excel E5 and G5 customers.

 

It's a shame...

 

Greetings.

LionRock
New Member

Hi!

 

I'm also trying to figure out what I'm missing here. Perhaps could it be the excel or version of product subscription?

amitchandak
Super User
Super User

@joshua1990 , seem like already check. This is source of info right now

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Thanks!

Yes, with this instruction I have tried to get this feature.

Unfortunately this is not working.

 

Did someone else have this feature now available in Excel?

 

Hi, same.

Could it be you need to be in the insider program ? 

https://support.office.com/en-us/article/create-a-pivottable-from-power-bi-datasets-31444a04-9c38-4d...

Also, I don´t even get your Excel screenshot. I have Excel2016. Do I need an addon? I have AnalysisToolpak installed.

And I can´t make a calculated table to be a featured table, only those imported via PowerQuery. Yet such calculated tables are most interesting as I want to analyse the *output* of my dataset (based on measures on a complex model) with the Excel solver, not input tables.

Alexander

Thanks for your reply!

Please see here for additional information:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/

 

There is nothing about "insider"

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.