Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SharePoint List and Power BI Integration

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 showi...
Data Modeling
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Qiuyun,

     

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

     

    Thanks,

    Chinmay

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

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