otisvillain
Board Regular
- Joined
- Mar 23, 2015
- Messages
- 77
Hey all,
I'm new to BI and have learned a ton the last week on it, what an amazing tool. I'm working through power query right now, and have a good handle on it. My question is this:
When new rows are added to my source data, and I refresh the PQ table, the new rows are added automatically which is great. However, when new columns are added to the source data, the new columns do not show up upon refresh of PQ table. I've tried a few different things and looked on the web, but have not gotten a concrete answer. Any ideas on how to add the new columns during refresh? Thank you
I'm new to BI and have learned a ton the last week on it, what an amazing tool. I'm working through power query right now, and have a good handle on it. My question is this:
When new rows are added to my source data, and I refresh the PQ table, the new rows are added automatically which is great. However, when new columns are added to the source data, the new columns do not show up upon refresh of PQ table. I've tried a few different things and looked on the web, but have not gotten a concrete answer. Any ideas on how to add the new columns during refresh? Thank you