Reply
acan107
Regular Visitor

How to create a dataset from multiple excel files (located on different SharePoint - Team Sites)?

Hi,

 

With Power BI Desktop, we can create a dataset which connects to multiple excel files. 

 

From Power BI Service, New -> Dataset, then click 'Get' button on the Files pane, input URL for SharePoint - Team Sites, navigate to the subfolders, I can select only one Excel file. A dataset with the same name (to the selected Excel file) would be created after the process, and I cannot find a way to add more Excel files to it.

 

I would like to create a dataset which connects to multiple excel files located on different SharePoint - Team Sites with Power BI Service. Can anyone help on this?

 

Thank You!

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Hi @acan107 ,

In Power BI Desktop, you could create a dataset that connects to multiple excel files

In Power BI Service, you could only create a dataset with one sharepoint sites.

But you could create a dataflow with multiple excel files in sharepoint firstly, then create a dataset with this dataflow.

For more details, you can read related document: Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
avatar user
Anonymous
Not applicable

Hi @acan107 ,

In Power BI Desktop, you could create a dataset that connects to multiple excel files

In Power BI Service, you could only create a dataset with one sharepoint sites.

But you could create a dataflow with multiple excel files in sharepoint firstly, then create a dataset with this dataflow.

For more details, you can read related document: Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)