Forum Discussion
Create new Table, filter empy values and concatenate values
Hi everyone, I've recently connected a data source in PowerBI from a SharePoint List, which originates from a PowerApps form. The information I'm working with appears a bit disorganized as it's inte...
Assuming this is all one table, you can do this in your transform data step (Table View --> Transform Data (under the home tab). Select the columns you want as 1 (e.g. Name_01, Name_02, etc.) and unpivot these. This should get you all names under one column. Repeat for your other fields
Thank you for your help, but in my case I am having a I/O trouble with the data connection since I managed to load the information from the Sharepoint List, as mentioned here- But when I go to Power Query and try to unpivot the columns, an error shows and tells me "We were unable to authenticate you with the credentials provided. Try again".