Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @scooby1380,
You can refresh the data in Power BI dekstop and publish it again. For more details, please check the online document.
Regards,
Frank
Hi @scooby1380,
Did you turn this option on in Power query?
Regards,
Frank
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
Hi Frank,
yes this option is selected.
thanks
scott
Hi Frank,
thanks for the response, however as per my post refreshing doesnt appear to bring in any newly added fields from dynamics 365
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |