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

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 automatically? I'll be importing the data every month and all my changes will be lost everytime I import. 

1 ACCEPTED SOLUTION

Accepted Solutions
tjd Established Member
Established Member

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

4 REPLIES 4
erik_tarnvik Established Member
Established Member

Re: Edit Data on Import

Power Query should be your ticket to solve this problem. That's pretty much what it is for.

tjd Established Member
Established Member

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

Super User
Super User

Re: Edit Data on Import

Actually the normal situation is that your query steps are applied again on each data refresh, so I wonder why your changes get lost.

Specializing in Power Query Formula Language (M)
mgallacher Frequent Visitor
Frequent Visitor

Re: Edit Data on Import

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!