Power BI dataflow not getting all IDs for a "Person and Group" SharePoint column
I have a dataflow that gets data from a "Person and Group" SharePoint column (pulls in the ID) but it's not bringing in the ID for every item that has a name in the column. In some cases where there is a name, it acts like the name isn't there and just puts "null" in the results table. Why does it do that for some, and for others, it pulls in the ID?
Solution
It turns out I needed to add the column name to a SelectColumns function in one of the applied steps of a query in the dataflow.
- Convert a value column into multiple columns in Power BI per customer
- Setting moving default start and end Date in power BI
- Power Query Conditional JOIN - JOIN with WHERE clause
- Power BI: Count the number of times a text appears in each row
- How to sort weekdays in Power BI based on today
- What are the minimum Azure permissions required to publish a Power BI report using "App Owns the Data"?
- Filter multiple visualizations to exclude values that have already been excluded
- How to count direct and indirect test cases for Features, Requirements, and Change Requests in Power BI using DAX?
- Group average as a baseline & individual variance to baseline
- DataFormatError whenever I filter a column
- How to structure input to use PowerBI REST API: multi-value parameters
- Data missing from basic visual in Deneb (vega-lite)
- Microsoft Power BI REST API PowerBINotAuthorizedException
- Filtering values on one visual affects filtering on second visual
- PowerBI Embed in Angular "User Owns Data" | Getting InteractionRequiredAuthError: AADSTS65001 while generating powerbi access token
- Displaying a Fixed Timeline in a Power BI Line and Clustered Column Chart with Slicers
- Integrate PowerBI report using 'embed for customer approach' to angular application which use OKTA to authenticate
- Why do fields still show in PowerBI when I have them filtered in the model?
- How to sort a line chart X-axis by a different column than displayed
- Row Comparison in PowerBI
- PowerBI Slicer showing single value from group of values
- Sorting Months in a Power BI Visual by Fiscal Year and Month
- Power BI report of excel data source
- PowerBI REST API get reports
- Reference another table when getting data from Python in Power BI
- Power BI - Powerpoint Export is Not even Showing
- Is it possible to schedule refresh in Power BI with Windows Task Schedule?
- PowerBi measure where the total is based on the legend and adjusts total for selected slicer
- DAX problem - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value
- How do I create a bar plot histogram of a parameter in power BI