Forum Discussion
Solved
Power BI and Excel Files / Dataset accessing multiple Excel files
Hi, I am working with a client and their data lineage looks the following: I am trying to replicate the same kind of lineage on my own tenant but when I upload and Excel file it beco...
Hi danielpaduck ,
You can follow the steps below to get the lineage view:
1. Navigate to the related workspace
2. Click on the tree icon in the upper right corner of the page that appears.
For your second question, you can create a dataset from multiple Excel files in Power BI following the steps below:
Open Power BI Desktop.
- Click on “Get Data” in the Home ribbon.
- Select “Excel” and navigate to the location of your first Excel file.
- Select the tables or ranges you want to import and click “Load”.
- Repeat steps 2-4 for each additional Excel file.
- Once all data is loaded, you can create relationships between the tables as needed and build your report.
Best Regards
Hi danielpaduck ,
You can follow the steps below to get the lineage view:
1. Navigate to the related workspace
2. Click on the tree icon in the upper right corner of the page that appears.
For your second question, you can create a dataset from multiple Excel files in Power BI following the steps below:
Open Power BI Desktop.
- Click on “Get Data” in the Home ribbon.
- Select “Excel” and navigate to the location of your first Excel file.
- Select the tables or ranges you want to import and click “Load”.
- Repeat steps 2-4 for each additional Excel file.
- Once all data is loaded, you can create relationships between the tables as needed and build your report.
Best Regards