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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

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


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors