Forum Discussion
Edit Data on Import
On the Home tab of PowerBI Desktop, you'll find the Edit Queries button. Clicking on it, opens the Power Query editor in which you can edit your data to your heart's content. After editing, click Apply and Load and your data model will be ready to use your edited data for creating visuals. Save the PowerBI Destop file. The next time you refresh your data from the data source, it will import, all the saved power queries will run, and you will have updated your PowerBI with new data in the format you desired. Hope this is what you were looking for.
On the Home tab of PowerBI Desktop, you'll find the Edit Queries button. Clicking on it, opens the Power Query editor in which you can edit your data to your heart's content. After editing, click Apply and Load and your data model will be ready to use your edited data for creating visuals. Save the PowerBI Destop file. The next time you refresh your data from the data source, it will import, all the saved power queries will run, and you will have updated your PowerBI with new data in the format you desired. Hope this is what you were looking for.
Actually the normal situation is that your query steps are applied again on each data refresh, so I wonder why your changes get lost.
They aren't Marcel. I'm a marketer trying to learn Power BI from scratch and didn't realize those steps would apply everytime. Thank you all for the explanations!
