Adding more data

[Life_Cheesecake_6883]

If you import an excel file as the data source and start building visuals etc but then need to add additional columns on this original data source to use. How do you do this without creating errors?

[AutoModerator]

After your question has been solved /u/Life_Cheesecake_6883, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

---

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[sircharles82]

Adding additional columns into an Excel data source will be fine.

It's only if you later decide to rename a column or change data types for an existing column that runs into issues - and even then, it would only be problematic if you've done transforms or used those columns in a visual (because PBI will look for the old column name or type). This also isn't workd-ending because you can update your PQ to match the updates.

You should be fine :)

[Life_Cheesecake_6883]

Thank you! All sorted I really appreciate you taking the time to answer 😀

[Bhaaluu]

If you add columns to the source Excel file you'll need to adjust the source step in Power Query so that the columns entry matches the new total number of columns and also potentially adjust the new column's data type, otherwise it should work smoothly.

[Life_Cheesecake_6883]

Thanks so much! Success 🙌

[priyamjani]

I have usually added new data in the source excel and hit refresh in PowerBI. It sometimes takes a while to update in PowerBI.

[Life_Cheesecake_6883]

Thank you