Not really sure if the title accurately describes what I'm asking about, but basically I'm just wondering what the pros/cons are to transforming data in power query vs doing it with DAX.
I prefer power query because I'm a bit more familiar with the M code, and I find the table transformations to be a little more intuitive. I have a data model that I update daily; every day I add in the previous day's data, which is usually less than a thousand rows of information.
I have it to where I have a folder that Power BI takes the data from, so I just save an excel file into the folder and I only have to do the transformations within Power BI one time and it takes care of it every other time.
But it seems like whenever I open my report on Monday morning it takes forever to load everything. With my data model I got my lookup tables by duplicating my main table several times then just removing the unecessary columns and removing duplicate values. Is this considered bad practice? It allows me to quickly and easily do what I need but I'm wondering if this is what's causing my program to run so slow due to it essentially having to do the transformations every time it's loaded (is this even true??).
I guess I'm just wondering if doing too many table duplications and stuff in power query would have a drastic impact on how long it takes for reports to load up. Thanks for reading.
