As a Power BI developer you don’t always create stuff from scratch. At the moment I need to deal with the work of previous developers as well: the good, the bad and the ugly…
ie. I am working on a report that has lots of Power Query steps, has a data model that isn’t necessarily looking like a star, has a lot of calculated columns, etc. The developers who built it are not available anymore. There is too much already built to throw it all away and start from scratch…
Generic question: what are your best practices in a situation like this?
In general I believe in doing transformations as close to the source. Unfortunately I can’t create or get specific database views, but for some tables I have translated the PQ steps to SQL code (which is basically my only/‘source step’ in Power query). Is that something you would recommend?
Is there a place on the internet with (the most common) transformations in M code on one side and SQL code on the other side?
Any advice for bringing the Calculated columns in DAX back to Power Query or even SQL?
(these seem a bit trickier, because of context etc). What are your experiences?
I would appreciate some advice, pointers or good blogs/websites or YT videos.
Thanks in advance