Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

Dataflows - Different Files in Sharepoint Site Folder

Helle Sirs & Masters

Source: There are two Excel Files ( not in the same structure, totally different); in the Sharepoint site, in same folder.
Goal: I am trying to create a Dataflow using these two files. What I am trying to do is; I will use these two Excel Files as two different Query in my Online Query Editor (Dataflow) but I cannot connect them.
I do not want to combine these two files. All the practices on the internet are regarding combining different files with the same structure in Sharepoint.

Can somebody guide me, on which data connector is available in the Dataflow creation process; should I use it?



Community Support
Community Support

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.           

Hello @v-stephen-msft 
First of all, thank you so much for sharing your time with a clear explanation.
When I connect to a "Sharepoint Folder" connector, I can see what is inside it. Please see the below picture, sorry I have strikethrough some sensitive information. 
I am trying to select a file, Transform Data on Online Query Editor. When I connect to dataflow in PBI Desktop, I can see the table but again only columns are available.
Am I missing any action while I am at the below step in the picture?




In your dataflow create two sources, one for each file.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors