Add column to existing table from dynamics 365

[scooby1380]

Hi Folks,

i have several tables in my dataset from Dyanmics 365.  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.

can someone advise if this is expected behaviour and if it is how do you add 1 column from the existing dataset?

thanks

[v-frfei-msft]

Hi @scooby1380,

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/dn708...

Regards,

Frank

[v-frfei-msft]

Hi @scooby1380,

Did you turn this option on in Power query?

 

Regards,

Frank

[scooby1380]

Hi Frank,

managed to figure out the issue.

i had used the option of Choosing specific columns previoulsly, when i then removed that aoolied step and refreshed the new fields were available.

thanks for your input

scott

[scooby1380]

Hi Frank,

yes this option is selected.

thanks

scott

[scooby1380]

Hi Frank,

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