ofrede
4 years agoNew Member
Status:
Investigating
*** BUG *** Error updating metadata when using Direct Query
We have an issue in PowerBI: A user has been making changes to a SQL view (added three columns) and used these new fields for some calculations in PowerBI. The user had no problems after updating th...
v-robertq-msft
4 years agoCommunity Support
Hi,
As far as I’m concerned, if the data model is changed in your Power BI dataset, you need to go to the Power Query to apply the changes to make the data model reconnect to the Power BI dataset.
You can use the Power Query Editor to connect to one or many data sources, shape and transform the data. You could modify the data in hand to meet your needs, make it more usable, and then load that model into Power BI Desktop.
For more info about the use of the Power Query, please refer to this link:
https://www.edureka.co/blog/introduction-to-power-query/
Thank you very much!
Best Regards,
Community Support Team _Robert Qin