Dataflows - Different Files in Sharepoint Site Folder

Hi Mercovito ,

I understand that you want to use these files as separate queries in the Online Query Editor, without combining them. I'll be happy to assist you with this. To connect and use these two Excel files as separate queries in the Dataflow creation process, you can follow these steps:

1. Open the Power BI service and navigate to the workspace where you want to create the Dataflow.

2. Click on the "Workspace" tab and select "Dataflows" from the dropdown menu.

3. Click on the "New" button to create a new Dataflow.

4. In the Dataflow creation process, you will be prompted to select a data connector. In your case, since you want to use Excel files from SharePoint, you can select the "SharePoint folder" connector.

5. Provide the necessary details to connect to your SharePoint site and navigate to the folder where the Excel files are located.

6. Select the first Excel file and click on the "Transform data" button to open the Online Query Editor.

7. Perform any necessary transformations or data manipulations for this file.

8. Close and apply the changes in the Online Query Editor.

9. Repeat steps 6-8 for the second Excel file, selecting it from the SharePoint folder and performing the required transformations.

10. Once you have created separate queries for both Excel files, you can save and close the Dataflow.

By following these steps, you should be able to create a Dataflow using two different Excel files in SharePoint without combining them. Each file will be treated as a separate query in the Online Query Editor.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.