Forum Discussion
Solved
Edit Data on Import
Most of the data I'm importing is exported out of cloud providers. Considering I can't edit the data in their database, is there a way to save query steps, or even better, edit the data on import aut...
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.
Power Query should be your ticket to solve this problem. That's pretty much what it is for.