Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Maintaning quickly an existing pbi model with loaded data by adding some data transformation logics

Hi,

I need to maintain an existing Power BI model having more one million of loaded data rows and several PQ logics.

When I add a data transformation I must wait more time before to accomplish another PQ logic and I need to continue the work in a quick manner, if possible.

Is it possible to perform the all data transformations to add the pbi model without that each single step is applied to the entire loaded data? In other terms, is it possible to implement the all data transformations to add and then to see the final result?

Thanks

3 REPLIES 3
lbendlin
Super User
Super User

Not really. (What's wrong with Notepad++ ?)  Have a look at ALM Toolkit, but that's more of a process management tool.

lbendlin
Super User
Super User

Avoid doing merges and appends until you have finished all other development. Better yet, avoid doing them in Power Query, and do them in the Power BI data model.

Anonymous
Not applicable

Hi Ibendlin,
do you know any external good tool to edit the M logics (not notepad, of course)?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors