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 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!

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

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community 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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Qiuyun,

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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
    Community Support
    8 years ago

    Hi Anonymous,

     

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

     

    Best Regards,
    Qiuyun Yu