3 docs tagged with "Power Query"

With the following steps, we create a new Power BI Desktop file (.pbix) and we connect with the Excel file containing the demo data (in multiple tabs).

After connecting the Excel file and its data tables, we will now proceed with preparing the individual dimension and fact tables using data transformation steps in Power Query. The first dimension we will prepare is the customer dimension containing respective master data.

6.7.1 | Overview