Add column to existing table from dynamics 365

Question

Hi Folks,&nbsp;i have several tables in my dataset from Dyanmics 365.&nbsp; I though any new fields added in dynamics would appear in Power BI after i refreshed the query, but that doesnt seem to be the case.&nbsp;can someone advise if this is expected behaviour and if it is how do you add 1 column from the existing dataset?&nbsp;thanks

v-frfei-msft · Answer

Hi&nbsp;scooby1380,
&nbsp;
You can refresh the data in Power BI dekstop and publish it again. For more details, please check the online document.
https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn708055(v=crm.8)
&nbsp;

&nbsp;
Regards,
Frank

scooby1380 · Answer

Hi Frank,&nbsp;thanks for the response, however as per my post refreshing doesnt appear to bring in any newly added fields from dynamics 365

v-frfei-msft · Answer

Hi&nbsp;scooby1380,
&nbsp;
Did you turn this option on in Power query?
&nbsp;
&nbsp;
&nbsp;
Regards,
Frank

scooby1380 · Answer

Hi Frank,&nbsp;yes this option is selected.&nbsp;thanksscott

scooby1380 · Answer

Hi Frank,&nbsp;managed to figure out the issue.&nbsp;i had used the option of Choosing specific columns previoulsly, when i then removed that aoolied step and refreshed the new fields were available.&nbsp;thanks for your inputscott

Forum Discussion

Add column to existing table from dynamics 365

5 Replies

Related content

Dynamic Column headers

Dynamic Column Name

Dynamic Variable in Calculated Columns

column deleted but column exists

Dynamic column comparison of last column