Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
tyxanu
Helper I
Helper I

PBi export to Excel, with Data Validation List

‎06-21-2022 12:49 AM

Hi,

 

Can anyone advise if the following is possible to achieve in PBi?

 

I need to create a table in PBi where I can add 2 empty columns(Column 1 and Column 2). Whenever someone exports the table as Excel, the exported Excel should be exported like in the below screenshot, with Data Validation Dropdown List applied already, allowing them only to select one of the 3 options.

tyxanu_2-1655797589239.png

 

tyxanu_0-1655797270541.png

 

Thanks in advance! 

 

Labels:
Message 1 of 3
520 Views
0
1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support
In response to tyxanu

‎06-23-2022 11:01 PM

Hi @tyxanu ,

 

As far as I know, Power BI doesn't support us to export Power BI Report to Excel with Data Validation List.

You may refer to the offical blog to learn more details about how to export the data that was used to create a visualization.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Message 3 of 3
457 Views
2 REPLIES 2
tyxanu
Helper I
Helper I

‎06-22-2022 03:26 AM

Anyone, any help? 

Message 2 of 3
467 Views
0
v-rzhou-msft
Community Support
Community Support
In response to tyxanu

‎06-23-2022 11:01 PM

Hi @tyxanu ,

 

As far as I know, Power BI doesn't support us to export Power BI Report to Excel with Data Validation List.

You may refer to the offical blog to learn more details about how to export the data that was used to create a visualization.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Message 3 of 3
458 Views

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All