Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Hi @Anonymous,
Glad to hear you find the solution. As the issue is solved now, I will close this thread.
Best Regards,
Qiuyun Yu
Hi Qiuyun,
I got the solution. I just changed the Column format in Query Editor and I can see the data now.
Thanks,
Chinmay
Hi Qiuyun,
Thanks for helping me out on this. Here is the snapshot of one of my coulmn having 'Choice'.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |