cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
scooby1380 Frequent Visitor
Frequent Visitor

Add column to existing table from dynamics 365

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

5 REPLIES 5
Community Support
Community Support

Re: Add column to existing table from dynamics 365

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

 

refresh.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
scooby1380 Frequent Visitor
Frequent Visitor

Re: Add column to existing table from dynamics 365

Hi Frank,

 

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

Community Support
Community Support

Re: Add column to existing table from dynamics 365

Hi @scooby1380,

 

Did you turn this option on in Power query?

 refres.PNG

 

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
scooby1380 Frequent Visitor
Frequent Visitor

Re: Add column to existing table from dynamics 365

Hi Frank,

 

yes this option is selected.

 

thanks

scott

scooby1380 Frequent Visitor
Frequent Visitor

Re: Add column to existing table from dynamics 365

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

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors