Drop down column in sharepoint list to use as a column

Question

Hi.

 

I have a requirement of using a dropdown value from a column in sharepoint list as a column header in Power BI report. Pls advise what will be the best way to achieve this.