SharePoint List and Power BI Integration

[Anonymous]

Hello,

I have connected SharePoint list with Power BI. SP list have multiple columns and some of them are set as 'Choice' (Drodown) datasets. When I am trying to connect with Power BI, it's showing '[List]' rather than showing multiple option in list. I am looking for all options selected for each action item. Is this a bug? Please help!

[v-qiuyu-msft]

Hi @Anonymous,

Glad to hear you find the solution. As the issue is solved now, I will close this thread. 

Best Regards,
Qiuyun Yu 

[Anonymous · Accepted solution]

Hi Qiuyun,

I got the solution. I just changed the Column format in Query Editor and I can see the data now. 

Thanks,

Chinmay

[Anonymous]

Hi Qiuyun,

Thanks for helping me out on this. Here is the snapshot of one of my coulmn having 'Choice'. 

[v-qiuyu-msft]

Hi @Anonymous,

How do you define the Choice column in the list? Would you please share how the list looks like? 

Based on my test, if the SharePoint online list is defined as below, we can retrieve the same data in Power BI desktop. 

Best Regards,
Qiuyun Yu