Archives

Scenario 1: Multiple fact tables thar are not related to each other Solution: Relate every dimension with their respective fact tables. Identify the shared dimensions. Relate them with every [...]

Query Folding is the capability of Power Query to delegate some of the transformations to the source to improve performance. In this post you will see its importance and good practices guide to [...]