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, 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.
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 |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |