Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Let me lay out this in a simple way.
I have a sharepoint list. It contains a column that supports multiple selections.
I need to build a report in Power BI. I am not doing "integration", I need to combine multiple lists, so started a fresh copy.
During data formatting stage, I am not able to expand the multi-select column into multiple rows.
The data shows up as Table data type.
However, I did expand two columns that are of PEOPLE type at sharepoint side. And they were single select columns.
How can I expand a multi-select column from sharepoint, via power bi.
Thanks
Solved! Go to Solution.
Found a workaround.
Swtiched the API version from 15 to 14 in advanced editor.
Which API version do we need to switch to
Found a workaround.
Swtiched the API version from 15 to 14 in advanced editor.
User | Count |
---|---|
11 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
16 | |
14 | |
8 | |
6 | |
6 |