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.
So I have imported a SharePoint list into Power BI and there are some name lookup columns. I have expanded these to First Name and Surname columns, then merged them into one column.
The Query has retained the two unmerged columns, but I don't really want them. If I delete them, and new entries are added to the sharepoint list, will PowerBI know to pull through the same data in the format I have specified, or will it kick off?
Thanks 🙂
Jemma
Solved! Go to Solution.
@Anonymous If you have done all these steps in "Power Query" then it will have a list of steps that was performed on the data after imported. So if there is any new data (after refresh) then it will apply the same steps again. You no need to do all these again.
Proud to be a PBI Community Champion
@Anonymous If you have done all these steps in "Power Query" then it will have a list of steps that was performed on the data after imported. So if there is any new data (after refresh) then it will apply the same steps again. You no need to do all these again.
Proud to be a PBI Community Champion
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |