In summary, the Power Query Editor interface in Power BI Desktop should contain the following types or groups of queries:
- Parameters:
- These will be used to store individual values essential to the data retrieval that could change, such as the names of servers, databases, and file paths.
- Staging Queries:
- These queries will not be loaded to the data model but will contain logic used by one or many other queries.
- For example, a staging query will connect to a specific SQL Server database based on two parameters (server and database) and this staging query will be used by the fact and dimension table queries.
- Fact and Dimension Queries:
- These queries will define the tables exposed to the data model layer and optionally ...