The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
Not really. (What's wrong with Notepad++ ?) Have a look at ALM Toolkit, but that's more of a process management tool.
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.
Hi Ibendlin,
do you know any external good tool to edit the M logics (not notepad, of course)?