Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 " Power BI integration", I need to combine multiple lists, so started a fresh copy of report.
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.
Found a workaround.
Swtiched the API version from 15 to 14 in advanced editor.
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |