PBi export to Excel, with Data Validation List

[tyxanu]

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.

Thanks in advance! 

[tyxanu]

Anyone, any help? 

[v-rzhou-msft · Accepted solution]

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.